Unless you create a user with O/S Authentication you have to store the Oracle password in a file. I store it in a hiden unix 700 file.
Syntax I use is (depending on password lenth)
USER="username"
PASS=`cut -b 12-17 /directory/.password`
COM2="connect $USER/$PASS"
COM3="sqlplus /nologon"
$COM3 <$COM2
execute package_name.package_procedure
ESQL
Try and keep you password in a single centralised area.
Cheers,




Reply With Quote