Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus scripts in Unix
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
![]() |
![]() |