exec sql_procedure('&1')
/
--show errors
spool off
exit sql.sqlcode
--/

#!/usr/bin/ksh
## create or replace procedure my_proc (p_rows in number) is
## begin
##    for i in (select object_id * rownum * rownum big_num, object_name, created
##                from user_objects where rownum <= p_rows) loop
##       dbms_output.put_line 
##           (lpad (i.big_num, 15, ' ')|| ' ' || rpad (i.object_name, 15, ' ')|| i.created);
##    end loop;
## end;
## /

user=xyz
pass=abc
db=dev1

num_rows=5

sqlplus -s /nolog <<EOF >tmp.txt
 connect $user/$pass@$db
  whenever sqlerror exit sql.sqlcode rollback
  set feedback off
  set serveroutput on size 1000000 format wrapped 
    exec my_proc($num_rows);
  exit sql.sqlcode;
EOF
rv=$?

echo "---- start output ----"
grep -v "Connected." tmp.txt
echo "---- end output ----"

echo Retval is $rv