How to Pass Value of Variable From PL/SQL Procedure to Shell Script

[pipo]

you're right for the user/pwd

note that you can also do :

sqlplus -s << EOF | while read VAR1 VAR2
user/pwd
...
EOF
do
echo $VAR1
echo $VAR2
done

of course if you are bringing complex values, you can either awk the result or use a delimiter and cut the returned string