#!/bin/ksh
## CREATE OR REPLACE PROCEDURE p1 (i_parm IN NUMBER, o_parm1 OUT NUMBER, o_parm2 OUT NUMBER)
## IS
## BEGIN
##    o_parm1 := 5 * i_parm;
##    o_parm2 := 10 * i_parm;
## END;
## /
my_in_parm=5
RETVAL=`sqlplus -s scott/tiger@dev <<EOF
set serveroutput on
declare
x number := $my_in_parm;
y number;
z number;
begin
  p1(x, y, z);
  dbms_output.put_line('KeepThis '|| y ||' '|| z);
end;
/
exit;
EOF`

Y=`echo $RETVAL | grep KeepThis | awk '{print $2}'`
Z=`echo $RETVAL | grep KeepThis | awk '{print $3}'`
echo o_parm1=$Y
echo o_parm2=$Z

>tt.ksh   
o_parm1=25
o_parm2=50

#!/bin/ksh
sqlplus -s scott/tiger@engdev <<EOF > tmp.txt
set pagesize 0 feedback off verify off heading off echo off
set serveroutput on
--select name from v\$parameter where name like 'nls%' and rownum <6;
select table_name from user_tables where rownum <6;
begin
  dbms_output.put_line('output parm#1');
  dbms_output.put_line('output parm#2');
end;
/
exit;
EOF

while read reslt_line
do
  echo "==>"$reslt_line
done < tmp.txt