how to access outparameter of a Procedure called inside a shell script

view full story

http://www.unix.com – Hi I am calling a PLSQL procedure inside a shell scipt. How to access out paramters of this procedure inside the mail shell script. I am using below peiece of code. Code: echo " inside PKG validation"       `sqlplus -s apps/CAF78GEN@OTST<<EOF           set heading off           set feedback off           set pagesize 0           set linesize 32767           VARIABLE l_out_put      VARCHAR2(1000)     &n (HowTos)