Press "Enter" to skip to content

How to Edit Stored Procedure in Oracle SQL Developer?

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:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community for developers and ask your question. It is FREE.

Vinish Kapoor


Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

Inline Feedbacks
View all comments