Re: Connecting to Oracle via Perl

2002-04-05 Thread Jared Still
On Wednesday 03 April 2002 06:53, Koivu, Lisa wrote: * Anytime I connect to sql*plus (I don't do it with DBI) I use the system call and refer to the parameter value in the hash within my connect string: $$parms_ref{'elvis_pw'}. I don't use DBI because my calls are to fire stored

RE: Connecting to Oracle via Perl

2002-04-03 Thread Farnsworth, Dave
You might want to check out Jared's site since he kind of likes perl. http://www.cybcon.com/~jkstill/util/ Dave -Original Message- Sent: Wednesday, April 03, 2002 7:58 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Environment is Oracle 8.1.6 NT 4.0 What is the best way to

RE: Connecting to Oracle via Perl

2002-04-03 Thread Koivu, Lisa
Hi Rick, Here's what I did... granted I have never been able to get os-authenticated logons to work on Windows (have you?) * Created a config file that has pairs of values (ex: elvis_pw elvis) * Created a module that accepts a hash as a parameter, reads the config file, populates

Re: Connecting to Oracle via Perl

2002-04-03 Thread Steven Lembark
-- [EMAIL PROTECTED] Environment is Oracle 8.1.6 NT 4.0 What is the best way to connect to Oracle using Perl? I do not want to hard-code password in script if not necessary. I could not find a way to embed in dsn creation. Any suggestions/working examples on how to achieve this is