ERRORTEXT

The ERRORTEXT option holds the text of the first error message that occurs when you execute a program or a statement.

Note:

The name of the error whose message is found in ERRORTEXT is contained in the option ERRORNAME. See the entries for ERRORNAME and TRAP for more information about handling Oracle OLAP errors. The ERRNAMES option 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.

Data type

TEXT

Syntax

ERRORTEXT

Examples

Example 11-31 ERRORTEXT with the SIGNAL Command

In a report program that uses a TRAP command to handle errors, you can use the SIGNAL command to send the appropriate error message to the current outfile.

DEFINE myreport PROGRAM
LD Monthly Report
PROGRAM
TRAP ON CLEANUP NOPRINT
PUSH month DECIMALS LSIZE PAGESIZE
LIMIT month TO LAST 1
   ...
POP month DECIMALS LSIZE PAGESIZE
RETURN
CLEANUP:
POP month DECIMALS LSIZE PAGESIZE
SIGNAL ERRORNAME ERRORTEXT
END