How to Edit Stored Procedure in Toad for Oracle?

  • Post author:
  • Post category:Toad
  • Reading time:1 mins read

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

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.