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,134 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 73

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle function works in 11g but not in 12c 21 72
Array of Key/Value Pairs as input to Oracle function 10 53
null value 15 94
Oracle Next Available Number 2 32
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

863 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now