Running and Debugging PL/SQL Programs

To execute a PL/SQL program against an online database:

Select View | Connection Navigator .
Expand Database and select a database connection.
In the database connection, expand a schema.
In the schema, find a folder with the name of the object type (for example, Package), and expand the folder.
In the folder, right-click the PL/SQL program, and choose Run or Debug from the context menu.
A Run PL/SQL or Debug PL/SQL window displays. Select a target and parameter(s), and click OK.
The program runs or debugs. Check status windows for progress and information.

Notes

More information about debugging PL/SQL programs is available in Debugging PL/SQL Programs and Java Stored Procedures.
A package body is in a folder within the corresponding Package folder.
When you run a procedure in the PL/SQL or Debug PL/SQL dialog, if the procedure makes a call to the PL/SQL web toolkit (owa. or htp.), you must call the procedure twice, using exception handling. Because the first call does not have any environment settings as required by the toolkit, an error will occur and you must call the procedure again, for example:
```
BEGIN

  HR.MY_PROC();

EXCEPTION

  WHEN OTHERS THEN

    HR.MY_PROC();

END;

        
```