Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

EXPTRACE

The EXPTRACE option controls whether system DML programs are traced when the PRGTRACE option is set to YES. The EXPTRACE option can be set to YES to help debug a user-defined program that calls system programs.

Data type

BOOLEAN

Syntax

EXPTRACE = {YES|NO}

Arguments

YES

All programs are traced, including system DML programs.

NO

(Default) System DML programs are not traced. Only programs other than system DML programs are traced.

Notes

How to Identify System DML Programs

Some OLAP DML statements are implemented as system DML programs. To send to the current outfile a list of system DML programs affected by EXPTRACE, issue the following statement.

SHOW AW(PROGRAM 'express')

Examples

Example 12-4 Tracing System DML Programs

After the following statements are issued, system DML programs such as LISTNAMES and ALLSTAT are traced in addition to user-defined programs.

PRGTRACE = YES
EXPTRACE = YES