Hi Amber,

You should be able to do somthing like...

#!/usr/bin/ksh

sqlplus -s scott/tiger@db << EOF > /tmp/result.$$
declare invar number;
declare outvar char(30);
exec myschema.mypkg.myproc(invar, outvar);
dbms_output.putline(outvar);
/
EOF

read result /tmp/result.$$
echo $result
rm -f /tmp/result.$$
exit 0

...if you do a search on the forum from "sqlplus" you should
see lots of good examples. The one above is just a quick and dirty
one.