Get value out of PL/SQL in shell script

[jiayng]

When i run this under shell script :

sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt $ret_val
v_tmp = $ret_val
echo v_tmp


Call_Path.txt contains the sql script.
No output for v_tmp.
if i change it to :
sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt $ret_val >$File
I can see the data exists on the File .
But i get the v_tmp.
May i know what is going on?

[marist89]

try something like:

v_tmp = `sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt`
echo $v_tmp