ORA-01405: fetched column value is NULL

Cause: 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 is an error unless you are running Oracle with DBMS=6, emulating version 6, in which case it is only a warning.

Action: 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.