How to Edit Stored Procedure in Toad for Oracle?

Follow these steps to edit stored procedure in Toad for Oracle.

  1. In Toad, click on menu Database > Schema Browser.
  2. Select the Procedure from drop-down menu or from the Tab (if Schema Browser configured as Tab).
  3. Then list of procedures will be displayed for the current user. Then select a stored procedure and do the right click on it.
  4. From the shortcut menu, click on Load in Editor option.
  5. Selected stored procedure will load in editor, there you can make the changes and after making the changes press F8 or F9 to compile the procedure in Toad.

See also:

Written by Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of and a question and answer forum for developers. You can connect with me on Facebook and Twitter.

Leave a Reply

Your email address will not be published. Required fields are marked *