Hi Allroundautomations,

I try to connect with PL/SQL Developer to a Physical Standby read/only database and get this error:

/************************************************************/
*** 2012-01-02 13:38:09.589
*** SESSION ID:(1428.1) 2012-01-02 13:38:09.589
*** CLIENT ID:() 2012-01-02 13:38:09.589
*** SERVICE NAME:(SYS$USERS) 2012-01-02 13:38:09.589
*** MODULE NAME:(plsqldev.exe) 2012-01-02 13:38:09.589
*** ACTION NAME:() 2012-01-02 13:38:09.589

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=10, mask=0x0)
----- Error Stack Dump -----
ORA-00604: se ha producido un error a nivel 1 de SQL recursivo
ORA-01405: el valor de la columna recuperada es NULL
----- Current SQL Statement for this session (sql_id=bd502nbh9abbs) -----
select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in ('PUBLIC', :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in ('TABLE', 'VIEW', 'PACKAGE','TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

/************************************************************/

Any ideas ?
(PL/SQL Developer Version 8.0.3.1510)

Regards
PGuti

It seems like an Oracle Server bug. Can you contact your Oracle Support representative about this issue?

Hi Marco,

Yes, I try with this and inform you. I can reproduce from sqlplus too.

Regards
PGuti

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

If you can reproduce it in SQL*Plus as well, then this reply from Oracle is obviously incorrect.

No Marco, I'm mistake from sqlplus on server we can't reproduce this is from sqlplus.exe on client with ORACLE_HOME use on sqlnet for PLSQL/Developer.

Regards
PGuti

I'm not sure I understand. Can you reproduce this from sqlplus.exe on the client?