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