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

Please let me know how to save the Stored Proc back to the DB after editing it in TOAD
Who is Participating?
sdstuberConnect With a Mentor Commented:
Press F9
click the button with the Green Triangle over the Blue DB-platters
in the menu Editor->Execute Statement
lwadwellConnect With a Mentor Commented:
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?
UmavmishraAuthor Commented:
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.
Did you change it?  Can you show the line(s) that are erroring?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.