Run Stored Procedures Interactively in Oracle

Q

How To Run a Stored Procedure Interactively in Oracle?

✍: FYIcenter.com

A

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.

 

Introduction to Oracle SQL Developer

⇒⇒Oracle Database Tutorials

2016-10-17, 202👍, 0💬