Re: PASSING A PARAMETER FROM KORN SHELL (NEWBIE)

> sqlplus -s users/password <<! 1>log_file

Note that calling up sqlplus in this manner will make your user/password available to everybody on the system via the ps command as long as the script runs.

one way around this is to include user/password as the first line of your script, which of course you wouldn't make readable by others, or better yet to create a on line file say my_pwd.sql with only user/password in it.

then the first line of your script can be

@my_pwd

and you can have others look at your scripts.

you would call sqlplus like this then

sqlplus @my_script $param1 $param2 etc.

Christian Received on Thu Mar 11 1999 - 17:47:14 CST