Previous
Previous
 
Next
Next

Handling Errors

When an error occurs anywhere in a program, Oracle OLAP performs the following actions:

  1. Stores the name of the error in the ERRORNAME option, and the text of the error message in the ERRORTEXT option.


    Note:

    When the ERRNAMES option is set to the default value of YES, the ERRORTEXT option contains the name of the error (that is, the value of the ERRORNAME option) and the text of the error message.

  2. When ECHOPROMPT is YES, then Oracle OLAP echoes input lines, error messages, and output lines, to the current outfile. When you use the OUTFILE or DBGOUTFILE statement, you can capture the error messages in a file. See Example: Directing Output to a File for an example of directing output to a file.

  3. When error trapping is off, then the execution of the program is halted. When error trapping is on, then the error is trapped.