All Forms errors belong to a standard type of FRM and are characterized by
An informative -type error message results from an error caused by some missing data or insufficient data and is not an error in the strict sense. No action is necessary by default, and further processing can be resumed after the occurrence of the error.
FRM-40350: Query caused no records to be retrieved. FRM-40353: Query Cancelled.
However, these types of errors can be tracked and replaced by customized messages to improve readability to the end user .
An error -type error message results from an error in the strict sense, which must be rectified before further processing can resume.
FRM-40202: Field must be entered. FRM-40360: Cannot Query Records here. FRM-40600: Record has already been inserted.
In Forms, few error-type error messages occur for which no action is required. A commonly occurring example is
FRM-40100: At first record.
When the cursor is in the first record in a block and the user presses the or key, this error is raised and requires no action to be taken. However, the same error resulting from the built-in FIRST_RECORD is a genuine failure, and the code following this built-in is executed after the FRM-40100 error message is displayed. The latter error might result when the user presses the Enter key and the corresponding KEY-NEXT-ITEM trigger has a call to FIRST_RECORD in it:
In this case, if the cursor is in the first record in the block, the code following the FIRST_RECORD built-in is executed after the error message FRM-40100 is displayed.
The only way to distinguish between an informative error message and an actual error message is by further processing, usually at runtime, without correcting the error. (Of course, the easy way is to look at the online help.)
Failure of built-ins or form object properties can be the cause of both informative-type and error-type error messages.
Error Severity Level
Most error messages, whether informative or error, are assigned a severity level. The severity level of an error message determines the damage caused by that error and whether that message can be suppressed. The severity level can be one of 0, 5, 10, 15, 20, 25, and greater than 25, which includes 99. Table 5.1 shows some examples.
Table 5.1. Error Messages and Severity Levels
|Error Number||Error Message||Level|
|FRM-40100||At first record.||5|
|FRM-40513||ORACLE error: Unable to get date/time from database.||10|
|FRM-40202||Field must be entered.||15|
|FRM-40602||Cannot insert into or update data in a view.||20|
|FRM-40355||Query will retrieve 1 record.||25|
|FRM-40007||Invalid user identifier or password. Re-enter.||25|
|FRM-40109||Cannot navigate out of current block in enter-query mode.||99|
Not every message with a severity level less than or equal to 25 can be suppressed. Error messages can be suppressed only for errors in which Forms can do away with the damage caused by the resulting error.
As an example, consider the message
FRM-40202: Field must be entered.
This message has a severity level of 15 and cannot be suppressed at all. The reason is that a mandatory item in a form should always have a value, irrespective of whether the resulting error message is suppressed.
Built-ins, Triggers, System Variables , and Exceptions
Oracle Forms has a set of built-ins, triggers, system variables, and exceptions to handle errors.
I will elaborate on each of these as we progress through the chapter. More specifically , I will address issues such as how to trap (suppress) informative and error messages using these different methods (that is, how to use the various system variables and triggers to trap messages).
Advanced GUI Development: Developing Beyond GUI
Advanced Forms Programming
Object-oriented Methods in Forms
Intelligence in Forms
Additional Interesting Techniques
Working with Trees
Oracle 8 and 8i Features in Forms Developer