Re: ERROR: oraperl, web, oracle

From: Scott Urman <surman_at_oracle.com>
Date: 1995/10/06
Message-ID: <454479$4ba_at_inet-nntp-gw-1.us.oracle.com>#1/1


In article <00997773.28921628_at_vms.csd.mu.edu>, 5p88zobairs_at_vms.csd.mu.edu writes:
|> Hi!
|>
|> I am trying to connect oracle and the webserver using oraperl2.4
|> I am using oracle7. When I run the oraperl script on the
|> command line it executes fine and the database query runs perfectly.
|> But when I try to run the same oraperl file from /cgi through
|> netscape... it gives a an error on the &oralogin(). On printing
|> the $ora_errstr I get:
|>
|> Error while trying to retrieve text for error ORA-02701
|>
|> Can someone please help me with this ?
|>
|> Thanks,
|>
|> Saima Zobair
|> zobair_at_mscs.mu.edu
Check the environment under which a CGI program runs. I suspect that either ORACLE_HOME or ORACLE_SID are not set properly. The best way to verify this is to do an 'env' inside the script - that way you can verify the variables. Received on Fri Oct 06 1995 - 00:00:00 CET

Original text of this message