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,224 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

737 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