|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Debugging Programs, 4 of 6
OLAP Worksheet allows you to use the TRACE or WATCH commands to interactively step through your program, pausing to examine the current values of OLAP DML objects and specifying how many program lines to execute. It also allows you to set watch points where execution will stop when data values meet certain conditions.
Access to the OLAP DML debugger is through the TRACE command, which controls the list of programs that are traced by the debugger. To use the TRACE command, you must be connected to OLAP Services using OLAP Worksheet.
To debug a single program, attach the analytic workspace in which the program resides, and use the TRACE command to add that program to the trace list.
To debug a program that is located on the same computer as that on which OLAP Services is running, take the following steps:
For more information on the TRACE command, see "OLAP DML Debugger Commands".
When your program runs, the debugger suspends the program's execution according to the settings you have specified and displays the double-line arrow prompt in the output pane of the command input window.
goagain to leave the debugging environment. The prompt returns to its single-line form (
->) in the output pane.