Hi Marco,
This is the Metalink S)ervice R)equest Update:
/******************************************************************/
Oracle Support - 09 January 2012 15:58:03 GMT+01:00 [ODM Action Plan]
OERR: ORA 1405 fetched column value is NULL (Doc ID 18810.1)
Error: ORA 1405
Text: 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 Oracle7 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.
This is a PL/SQL type error, a query returning a null value, is not an error.
appears the vendors code is not handling a null value correctly.
ACTION PLAN:
You need to contact the vendor and find out what this means:
ORA-01405: fetched column value is NULL. <<<<<<<<<<<<######################################
You need to get from vendor what query is failing,
or why the null value is not being handled correctly.
getting ora-1405 is not an oracle error in the since that oracle is wrong,
it is a message or an alert telling us that a null value has been returned,
so is a null value the appropriate value at this point in the code?
if so, then the code needs to be modified to handle the null.
if the null is not an appropriate value at this point, then
we need to know from vendor what query is failing.
/******************************************************************/
Seems that Oracle view the problem at application level, any ideas ?
Regards
PGuti