How to Edit Stored Procedure in Oracle SQL Developer?

How to Edit Stored Procedure in Oracle SQL Developer?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

Follow these steps to edit stored procedure in Oracle SQL Developer.

  1. In Oracle SQL Developer, click on the Schema to expand the node on the left side.
  2. Then click on the Procedure node to expand.
  3. List of Stored Procedure will display.
  4. Then click on the procedure name which you want to edit.
  5. It will open on the right side pane in SQL editor window.
  6. There you can make the changes and click on the Gear icon to compile.

See also:

This Post Has 2 Comments

  1. akhil April 5, 2021

    i need help regarding creation of package and package body

    1. Vinish Kapoor April 7, 2021

      Please ask your question on orclqa.com

Comments are closed.