Oracle SQL Developer - How To Run a Stored Procedure Interactively

How To Run a Stored Procedure Interactively

Q

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

✍: 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.

2007-04-28, 4991👍, 0💬

How To Run Stored Procedures in Debug Mode
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode: Open... 2007-04-28, 7107👍, 0💬

How To Assign Debug Privileges to a User
How To Assign Debug Privileges to a User? - Oracle DBA FAQ - Introduction to Oracle SQL Developer In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default dat... 2007-04-28, 6085👍, 0💬

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... 2007-04-28, 4992👍, 0💬

How To Create a Procedure Interactively
How To Create a Procedure Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure win... 2007-04-28, 4638👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.