Oracle error ...Connect! Error while ... error ORA-12154

From: <amita_rohatgi_at_my-deja.com>
Date: Fri, 17 Sep 1999 00:18:05 GMT
Message-ID: <7rs1bk$7p4$1@nnrp1.deja.com>

Hi,

software configuration of my system:

Redhat5.2 with Oracle8.0.5.1
Perl5

I have some APIs in Proc*C which connect and query the Oracle database. My application my_appl.exe uses these APIs and successfuly access the database.
I have a CGI-PERL script which executes this my_appl.exe. When I execute the CGI-Perl script from the command line, the myappl.exe runs successfully and I get the data from the database.

$option = 'B';
$login = 'queen';
$pwd = 'waves';

$my_appl = "/home/enuntio/proc/enun09_15_99/upds_test";

@output = `$my_appl $option $login $pwd`; print("\n");
for ($x=0; $x <= $#output; $x++) {

print ("$output[$x]\n");
}

But, when trying to execute the CGI-Perl script from the browser, I get the following error message:

Oracle error while executing Connect! Error while trying to retrieve text for error ORA-12154

Any help is appreciated.

Regards,
Amita

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 16 1999 - 19:18:05 CDT