oraperl/sqlnet/ora_login question

From: Grace Tsai <gtsai_at_ribm00.rhic.bnl.gov>
Date: 1997/09/30
Message-ID: <34316AF1.167E@ribm00.rhic.bnl.gov>#1/1

We recently upgraded our Oracle from 7.2.3 to 7.3.2. The server software is installed on an AIX machine, and the UNIX client software is installed in two AIX machines (one of them is the server also) and three SGI/IRIX machines.

In the old version (7.2.3), we had both SQL*NET v1 and v2 coexisting in our server, users could use the following cgi script to access the ORacle database (We have five databases in our ORACLE system) on the Web:

---

#!/usr/local/bin/oraperl

$lda=&ora_login("t:<the server address>:<database
name>","<Oracle_userid>","<Oracle_password>") || die "Open failed";

$csr=&ora_open($lda,"select.....

exit

---

But after upgrading to the new version (7.3.2), this script no longer works. Now, we only have SQL*NET v2 in our server, we no longer have v1. We have to define two environment variables and remove the "t:<the server address>:" in ora_login. The new cgi script should look like as follows:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

#!/usr/local/bin/oraperl

$ENV{'ORACLE_HOME'} = "<oracle home>";
$ENV{'TWO_TASK'} = "<database name>";

$lda=&ora_login("<database name>","<Oracle_userid>","<Oracle_passwd>")
|| die "Open failed";

$csr=&ora_open($lda,"select...

exit

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Now, some of our oraperl users have complained. One of them have a very complex web interface to their oracle database done with oraperl and containing many scripts. They dont want to change their scripts, because there are so many. Does anybody know how can I let them still use the old scripts in this new version? Any suggestion would be greatly appreciated. Thanks in advance.

Grace Tsai
Brookhaven National Laboratory Received on Tue Sep 30 1997 - 00:00:00 CDT