Re: sqlplus execute cmd

Watch out with this sqlplus $username/$password stuff ... that command line puts your username and password in plain sight on the list of Unix process (ps -ef | grep sqlplus) for any Unix user to see... your script should be able to embed the password at least in the Here document to provide a tad more security.

Martin Doherty

Hanspeter 'Happl' Oberlin wrote:

>In article <3de50d10.18786725_at_news.dal.ca>,
> meinhfxGARBAGE_at_hotmail.com (tony) wrote:
>
>
>
>>I have a script which basically does this:
>>
>>sqlplus $username/$password @plsql_spec
>>sqlplus $username/$password @plsql_body
>>
>>I would then like to do
>>
>>sqlplus $username/$password execute plsql_spec.proc_1
>>
>>This gives me a sqplus command error showing that execute is not an
>>option. Within sqlplus execute plsql_spec.proc_1 works fine. Any
>>idea how I can work around this?
>>
>>
>
>sqlplus $username/$password <<EOF
>execute plsql_spec.proc_1
>EOF
>
>(that technique is called "here file")
>
>or
>
>sqlplus $username/$password @proc_1
>
>and proc_1.sql contains the following to lines
><--
>execute plsql_spec.proc_1
>exit
>-->
>
>Greetings from Switzerland -- Gruesse aus der Schweiz
>Happl
>
>
Received on Wed Nov 27 2002 - 13:57:33 CST