Database Error Messages

A query returned a row containing a NULL value for one of the selected columns, but the program variable associated with the column by the define call (the define variable) did not include an indicator variable. The define variable buffer in the program remained unchanged.

To resolve the issue, perform any one of the following:

• Associate an indicator variable with all define variables to record the presence of the NULL value. This technique permits your program to take a specific action if a NULL value is returned.
• Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution.
• Revise the query to eliminate inclusion of columns that

/ might contain a NULL value.

The INTO clause of a FETCH operation contained a NULL value, and no indicator was used. The column buffer in the program remained unchanged, and the cursor return code was +2. This was an error unless you are running Oracle with DBMS=6, emulating version 6, in which case it was only a warning.

You may do any of the following:

• Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution.
• Use an indicator to record the presence of the NULL. You probably should use this option when you want a specific action to be taken when a NULL arises.
• Revise the cursor definition so that no columns possibly containing NULL values are retrieved.

The INTO clause of a FETCH operation contained a NULL value, and no indicator was used. The column buffer in the program remained unchanged, and the cursor return code was +2. This was an error unless you are running Oracle with DBMS=6, emulating version 6, in which case it was only a warning.

You may do any of the following:

• Use the NVL function to convert the retrieved NULL to another value, such as zero or blank. This is the simplest solution.
• Use an indicator to record the presence of the NULL. You probably should use this option when you want a specific action to be taken when a NULL arises.
• Revise the cursor definition so that no columns possibly containing NULL values are retrieved.