Re: Oracle -> Perl

Yes, but I suggest you do a careful reading of the DBI docs.

You should also get the DBI book from O'Reilly.

Just search for DBI on amazon.com.

Jared

On Mon, 9 Oct 2000, DEMANCHE Luc (Cetelem) wrote:

> 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
>
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Tue Oct 10 2000 - 01:04:59 CDT