Press "Enter" to skip to content

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:

Vinish Kapoor is created, written, and maintained by Vinish Kapoor. It is built on WordPress, and hosted by Bluehost. Connect with Vinish on Facebook, Twitter, and GitHub.

You may also like: