No need to know abt err 65285, Silvio. Here are the steps to make table_info( ) work correct for Oracle 7.3.4 server.
1. Copy the entire code of table_info( ) sub into ur program.
The code 'll be residing in $perl_home_dir/site_perl/5.6.1/sun4-solaris-64int/DBD/Oracle.pm module,
if u r on Solaris or search for Oracle.pm in $perl_home_dir.
2. Name the subroutine as DBD::Oracle::db::table_info.
3. Add 'use DBD::Oracle' to ur program.
4. In the copied code,go to last SELECT stmt block and replace NULL ( for TABLE_CAT) to some dummy value. I'm afraid
'' (space) may not work. I used V$DATABASE.NAME.
5. Same trick can be applied to other catalog methods column_info(), primary_key_info() etc.
Ravi
Silvio Wanka wrote:
Tim Bunce wrote:
On Wed, Jun 09, 2004 at 04:16:22PM -0700, Ravi Kongara wrote:
does this command output anything useful for you:
oerr ora 65285
Tim.
Hi Tim,
I'm afraid not:
# client % echo $ORACLE_HOME /opt/oracle/v817 % which oerr /opt/oracle/v817/bin/oerr % oerr ora 65285 % oerr ora 65285 | wc -c 0 # server % echo $ORACLE_HOME /opt/oracle/v7344 % which oerr /opt/oracle/v7344/bin/oerr % oerr ora 65285 % oerr ora 65285 | wc -c 0
Silvio
