Error and Debugging Options


A number of options determine how errors are handled and what happens during debugging. These options are listed in Table: Error Handling Options and Table: Debugging Options.

Error Handling Options

Statement Description
ERRNAMES
An option that controls whether the value of the ERRORTEXT option contains the name of the error (that is, the value of the ERRORNAME option) as well as the text of the error message.
ERRORNAME
An option that contains the name of the first error that occurs when you execute a program or when you execute an OLAP DML statement.
ERRORTEXT
An option that contains the text of the first error message that occurs when you execute a program or a statement.
PERMITERROR
An option that determines whether or not an error is signaled on attempted access of a variable for which read or write permission is denied by a PERMIT command.
MODERROR
Specifies the action to be taken when a model equation diverges or a block fails to converge. The possible values are STOP, CONTINUE, and DEBUG.
BADLINE
When a program, model, or input file is executing, an option that controls whether Oracle OLAP records, in the current outfile, the line that caused an error.
INF_STOP_ON_ERROR
An option that specifies the behavior of Oracle OLAP when an error is reached when reading from a file using the INFILE command
WRAPERRORS
An option that determines if Oracle OLAP displays long error messages as multiple lines with each line being 72 characters in length.

Debugging Options

Statement Description
EXPTRACE
An option that controls whether system DML programs are traced when the PRGTRACE option is set to YES.
PRGTRACE
An option that determines whether each line of a program is recorded in the current outfile or in a debugging file during execution of the program.
MODTRACE
An option that controls whether each equation in a model is recorded in a file during execution of the model.
MODERROR
Specifies the action to be taken when a model equation diverges or a block fails to converge. The possible values are STOP, CONTINUE, and DEBUG.