Shell script to catch PL/SQL return values

[Quoted] [Quoted] I need some help from the experts on PL/SQL and Shell scripting. I need a shell script that runs a PL/SQL procedure and gets the values returned from the PL/SQL procedure into the shell variables. The PL/SQL procedure returns multiple values.

[Quoted] [Quoted] I was able to assign a single return value from the SQL statement to the shell variable as below, but what about multiple values...

[Quoted] bash-2.05$ more shellsql.sh

#!/bin/ksh

#set -x

[Quoted] outvar=`sqlplus -s apps/apps <<EOF

[Quoted] set heading off feedback off verify off

[Quoted] select bug_number from ad_bugs where bug_number='4289310';

exit

EOF `

echo $outvar

Thanks for your help on this. Received on Tue Jun 27 2006 - 12:49:17 CEST