Re: SQLPlus scripts in Unix

From: Mirza Mohsin Beg <mbeg_at_netearnings.com>
Date: Wed, 02 Jun 1999 21:11:01 -0700
Message-ID: <37560055.5828496C@netearnings.com>

How about you execute your SQL code via a PL/SQL procedure that you schedule via DBMS_JOB package. That way your DB Server will run it internally.

Of course if you are spooling output, you might want to use UTL_FILE package to do file I/O.

-M

Brian Peasland wrote:

> I have an easy question. I want to set up a cron job to run an SQLPlus
> script at certain times. My dilemma is how to hide the userid/password. If I
> store that info in the script, I'm afraid others might be able to "see" it.
> How can I automate some script processing and still be able to maintain
> security. How do you do it?
>
> Thanks in advance!
> Brian Peasland
> peasland_at_msn.com
Received on Wed Jun 02 1999 - 23:11:01 CDT