Solved

After editing the stored procedure in TOAD, how do I load/save  it back to to the database

Posted on 2009-05-14
4
2,180 Views
Last Modified: 2013-12-18
Please let me know how to save the Stored Proc back to the DB after editing it in TOAD
0
Comment
Question by:Umavmishra
  • 2
4 Comments
 
LVL 25

Assisted Solution

by:lwadwell
lwadwell earned 200 total points
ID: 24392626
You need to compile it ... use F9 to compile the script in the procudure editor.  Or press the "execute statement" button, or select if from the Editor drop-down.

Is this what you mean?
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 300 total points
ID: 24392635
Press F9
or
click the button with the Green Triangle over the Blue DB-platters
or
in the menu Editor->Execute Statement
0
 

Author Comment

by:Umavmishra
ID: 24392659
I am getting a compilation error saying "IN" is not a valid integer value.

This is an existing procedure and is giving the error on compilation.
0
 
LVL 25

Expert Comment

by:lwadwell
ID: 24392869
Did you change it?  Can you show the line(s) that are erroring?
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
su - oracle could not open session 6 95
How to free up undo space? 3 50
PL SQL Developer 7 52
Trying to get a Linked Server to Oracle DB working 21 68
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question