-------- Original Message --------
Subject: Re: ORA-65285 by $dbh->tables if DBD::Oracle build with 8.1.7 and server is 7.3.4
Date: Thu, 10 Jun 2004 09:55:26 -0700
From: Ravi Kongara <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Silvio Wanka <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
I could pin-point the cause of this problem. The Oracle DBD driver's sql statement is selecting
*NULL* value for TABLE_CAT, as this is not applicable for Oracle. This NULL value in SELECT stmt
is throwing up the mysterious error code (65285). When i searched thru blogs, came to know that others
also had similar error when they tried to select NULL in PeopleSoft related application.
They could overcome this problem by changing NULL to ' ' (space ).
I think we don't have that privilege here to alter SELECT stmt, as it's issued by driver.
What else can be done.?
Ravi
Silvio Wanka wrote:
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
