Calling PL/SQL from unix
Mark Adamson, May 25, 2017 - 2:09 pm UTC
While the example works it possibly exposes the password to the ps command. I would recommend
#!/bin/ksh
sqlplus /NOLOG <<EOSQL
connect uname/pass@db
exec my_proc
exit
EOSQL
May 26, 2017 - 1:19 am UTC
"it possibly exposes the password to the ps command"
How ?
There is no user/pass on the command line in my example.