Oracle -> Perl

From: DEMANCHE Luc (Cetelem) <luc.demanche_at_cetelem.fr>
Date: Mon, 9 Oct 2000 09:43:54 +0200
Message-Id: <10644.118757@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C031C4.ACE3A508
Content-Type: text/plain;

charset="iso-8859-1"

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
luc.demanche_at_cetelem.fr

------_=_NextPart_001_01C031C4.ACE3A508
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>

<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>Oracle -> Perl</TITLE>
</HEAD>
<BODY>

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 =3D =
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
 luc.demanche_at_cetelem.fr
Received on Mon Oct 09 2000 - 02:43:54 CDT