|Oracle9i OLAP Services Developer's Guide to the OLAP DML
Release 1 (9.0.1)
Part Number A86720-01
Debugging Programs, 2 of 6
There are two main methods for debugging OLAP DML programs: using a debugging file, and using the OLAP DML debugger from within OLAP Worksheet. The method that you use depends on the degree of debugging that you want to perform and how the OLAP DML code is executed.
If you are executing OLAP DML code through the OLAP API, you can use a debugging file that logs the progress of program execution so you can analyze it for errors.
For more information on working with a debugging file, see "Debugging with a Debugging File".
If you are executing OLAP DML code from within OLAP Worksheet, you can use the OLAP DML debugger when you want to debug by interactively stepping through a program one line at a time while displaying the current values of OLAP DML objects.
The exact steps that you take to use OLAP Worksheet depend on the location of the program you want to debug and the type of session in which OLAP Worksheet runs. For more information, see "Debugging with OLAP Worksheet", and "OLAP DML Debugger Commands".