ORA-01405 on Physical Standby read/only database

[datadeconline]

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 ID1428.1) 2012-01-02 13:38:09.589
*** CLIENT ID) 2012-01-02 13:38:09.589
*** SERVICE NAMESYS$USERS) 2012-01-02 13:38:09.589
*** MODULE NAMEplsqldev.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

 

[Marco Kalter]

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

 

[datadeconline]

Hi Marco,

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

Regards
PGuti

 

[datadeconline]

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.

 

[Marco Kalter]

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

 

[datadeconline]

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

 

[Marco Kalter]

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