Ravi Kongara wrote:
Hi Silvio,
I also ran into the same problem when i tried to reconcile meta data of
source and
target tables in a typical datawarehouse application. My situation is
also identical as urs.
DBI is built with 8.1.7.4 and 'm trying to access table_info( ) of 7.3.4
server and getting following error.
"DBD::Oracle::st fetchrow_array failed: ORA-65285: Message 65285 not
found; product=RDBMS; facility=ORA (DBD ERROR: OCIStmtFetch) [for
Statement...".
I'm getting similar error with $dbh->column_info( ) as well.
Sql stmt is working fine,if i run in SqlPlus 8.1.7.
Have u got any help ?
Not really. The tip using ALTER SESSION does not works. Maybe we must
first enable tracing in SQL*NET. Our trace location is not specified
in ora.ini, so it should be appear in rdbms/log but does not. We will
try to upgrade the server from 7.3.4 to 8.0.6. The underlying OS will
not be supported by newer Oracle releases and an OS upgrade is also
not possible.
Sqlplus shows at startup the server releases, maybe it uses different
methods to communicate with a 8.* and a 7.* server. It is not linked
with libclnts[ht].
We should not use software from last century ;-), Silvio
