running an SQL script via Perl 5.003

From: ZEITGEIST <restaurant_at_the.end.of.the.universe>
Date: 1997/03/21
Message-ID: <5gsqj0$27f@news2.ee.net>#1/1

Greetings all -

I am running Oracle 7.3.2 and would like to use a Perl script to run an SQL script.

Currently, the Unix shell script simply says the following (or close to it) -

sqlplus username/password < myscript.sql

(1) I don't like the username/password in the script, but this user only has
select access against one table. Any ideas on how to hide it ?

(2) How do I rewrite the above line for Perl 5.003 ? I tried using
the OPEN(blah,|blah) (this is from memory so don't quote me) but it didn't work. Does anyone have any ideas ?

I tried posting this in the Perl NG and no one responded.

Any help would be appreciated !

Brett
zgeist_at_ee.net Received on Fri Mar 21 1997 - 00:00:00 CST