Re: Oracle via perl (using DBI)

you have to set all the environment variables for oracle in your perl script.

like $ENV{ORACLE_HOME}="/tools/oracle/...";

there are several of them you might need to set depending on your environment.

our environment is set up so that when I run the startup script for sqlplus it sets some env variables. if I set those same ones in my perl script, I have no problems.

I am not a oracle-setup person, just an app developer. there is a Perl DBI mailing list. go to perl.com and find out how to sign up.
those ladies/guys can answer all your DBI specific questions

good luck

irisas_at_cs.bgu.ac.il (Iris Ashkenazi) wrote in message news:<423bbcae.0112170444.1f67788_at_posting.google.com>...
> Hello,
> I'm using the DBI to connect to oracle DB via perl.
> When using the DBI->connect method the following error message
> appears:
> "Error connecting to database; Error while trying to retrieve text for
> error ORA-12545 (DBD: login failed) "
>
> What should I do ?
>
> Thanks,
> Iris
Received on Mon Dec 17 2001 - 23:05:53 CET