Hi Guys,
I was just wondering if anybody can help me with this problem.

OK, how we can get a value back from PL/SQL Script (not stored procedure/function)

See the below example: (for example aaa.sh)

#!/bin/ksh

VALUE=`sqlplus -s user/password@test_id <<EOF
@xxx.sq
EOF`
echo $VALUE

And xxx.sql is like below:

DECLARE
x number = 10;
y number = 0;
BEGIN
y = x /2;
END;
/
exit

OK, I'd like to get the value of "y" variable from xxx.sql back into the calling aaa.sh VALUE variable...

Mind you "exit y;" doesn't help...

Thanks in advance.


l