To run a program unit in the PL/SQL Interpreter:
If the PL/SQL Interpreter is not already displayed, choose ToolsPL/SQL
Interpreter to display it.
At the Interpreter's PL/SQL>
prompt, type the name
of the program unit followed by a terminating semi-colon (;
).
If the program unit requires any arguments, be sure to supply them in parentheses.
For example: getdata(SCOTT);
Press the Enter or Return key to produce one of the following reactions:
Any output generated by the program unit is displayed at the command
line, and the PL/SQL>
prompt returns to indicate successful
execution.
The secondary prompt appears (+>
) indicating you have not finished entering
an executable statement. If you forgot the terminating semicolon, enter
it now and press Enter or Return. Otherwise, right-click and choose
New Prompt.
Runtime errors are displayed at the command line, then the PL/SQL>
prompt appears. You need to edit or debug your program unit.
(debug n)PL/SQL>
.
Next step
Inserting a Navigator pane in the PL/SQL Interpreter
About debug commands in the PL/SQL Interpreter
Examining or changing local variables
Copyright © 1984, 2005, Oracle. All rights reserved.