Oraperl CGI Problem! Help...

From: Angus Lai <orange_at_globalserve.net>
Date: 1997/03/31
Message-ID: <33402945.68F2@globalserve.net>#1/1

Dear friends,

        I using oraperl to retrieve data from oracle, the following code work
well on unix prompt (By typing ./ScriptName to test).

---

#!/usr/local/bin/oraperl

require 'cgi-lib.pl';
print &PrintHeader;

$CityGetBrife = "select address from TABLE where upper(city) like
‘%TORONTO%’";
#Connect Oracle
  $lda = &ora_login($DataBase, $ID, $Pass)||print "login error :$ora_errstr<p>\n";

  #open and send SQL
  $csr = &ora_open($lda, $CityGetBrife, 6)||print "Open Error :
$ora_errstr<p>\n";

  while(($tra) = &ora_fetch($csr)) {

        push(@BranchList, $tra);
  }
  print @BranchList;

 do ora_close($csr) || die "can't close cursor";  do ora_logoff($lda) || die "can't log off Oracle";

---

But When I run the program with web
broswer(http://domain/ScriptName.pl), It cannot login Oracle.
$ora_errstr is : Error while trying to retrieve text for error ORA-12546

Dear friend, What is this error message means? can u think of some solution? What's happening?

   Thanks A LOT.

-Angus Received on Mon Mar 31 1997 - 00:00:00 CST