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 node with the name of the object type (for example, Package), and expand the node.
In the node, right-click the PL/SQL program and choose Run or Debug.
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 node within the corresponding Package node.
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;        
```