Run Stored Procedures Interactively in Oracle


How To Run a Stored Procedure Interactively in Oracle?



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.


Run Stored Procedures in Debug Mode in Oracle

Create a Stored Procedure Interactively in Oracle

Introduction to Oracle SQL Developer

⇑⇑ Oracle Database Tutorials

2019-01-12, 1503🔥, 0💬