Learn the purpose and how to unravel the ORA-01405 error message in Oracle.
Description
When you stumble upon an ORA-01405 error, the following error message will appear:
ORA-01405: fetched column value is NULL
Cause
You tried to execute a FETCH, however the INTO clause again a NULL value.
Resolution
The option(s) to resolve this Oracle error are:
Option #1
Try the usage of the NVL characteristic to substitutes a value when a null value is encountered.
Option #2
Try re-writing your cursor so that no NULL values are returned.