RE: Oracle -> Perl

Luc:

     So does our department. We do not use OAS, but someone from the PERL-DBI mailing list advised me that it has support for Perl in it. I installed the Oracle client and programmer options on our web server. Then I downloaded DBD:Oracle and DBI from the cpan website. I had some difficulty making the DBD:Oracle and the PERL mailing list was extremely helpful. ( I have Oracle 8.1.5) I suspect it would be easier with Oracle 7.3.4. DBI HOME PAGE AND ARCHIVES:
<http://www.symbolstone.org/technology/perl/DBI/> http://www.symbolstone.org/technology/perl/DBI/ To subscribe to this list, please visit: <http://www.isc.org/dbi-lists.html> http://www.isc.org/dbi-lists.html If you are without web access, or if you are having trouble with the web page, please send mail to dbi-users-request_at_isc.org with the subject line of: 'subscribe'.

Mary Ruiz / Atlanta

-----Original Message-----
From: DEMANCHE Luc (Cetelem)
Sent: Monday, October 09, 2000 4:51 AM
To: Multiple recipients of list ORACLE-L Subject: Oracle -> Perl

Hi all,

Our Intranet department tries to connect to Oracle using a Perl script. Is this script enough for the connection ? What about OAS ?

We run on Solaris 2.6, Oracle 7.3.4 and OAS 4.0.7

#!/usr/local/bin/perl
use DBI;
my($db, $csr, $ret_val);
# Connect to an Oracle database.
# Modify the following with suitable values for the net alias and your
# db userid and password

  $db = DBI->connect('dbi:Oracle:your_db_alias','your_user','your_password')

        or die "Unable to connect: $DBI::errstr";

TIA Luc Demanche
Cetelem
Tel.: 01.46.39.14.49 Received on Mon Oct 09 2000 - 09:47:34 CDT