Unable to connect to Oracle Database

From: Nicolas Moeri <moeri_at_sgi.com>
Date: Sat, 10 Jul 1999 11:16:24 -0700
Message-ID: <37878DF8.3DF833B6@sgi.com>

I've written a Perl CGI script to access an Oracle Database from a Webpage.

I'm using Perl 5.004 with CGI.pm and oraperl.

Launched from the shell, the script works, but from the web page &ora_login produces the following error:

ORA-00604: error occurred at recursive SQL level (DBD: login failed)

To try to fix the problem, I've set the following environment variables in the perl script:

$ENV{"ORACLE_HOME"}="/oracle/product/8.0.5";
$ENV{"ORACLE_SID"}="SOHO";
$ENV{"LD_LIBRARY_PATH"}="/oracle/product/8.0.5/lib";
$ENV{"SGI_ABI"}="-32";
The error remains.

What should I do ?

Thanks for your answers to moeri_at_sgi.com Received on Sat Jul 10 1999 - 13:16:24 CDT