How To Run a Stored Procedure Interactively


How To Run a Stored Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer



If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out:

  • Open you connection name, like Local_XE.
  • Open Procedures.
  • Right-click the procedure name: HELLO.
  • Select Run. The Run PL/SQL window shows up. SQL Developer creates a simple anonymous code block for you to run the stored procedure.
  • Click OK. SQL Developer runs the anonymous code block, which calls your store procedure.

You should see the following in the Running Log area:

Connecting to the database Local_XE.
Hello world!
Welcome to PL/SQL!
Process exited.
Disconnecting from the database Local_XE.

2007-04-28, 5470👍, 0💬