Shell Programming and Scripting

RET_VALUE=`sqlplus -s ${FCP_LOGIN} <<EOF 
SET TERM ON 
SET ECHO ON 
SET SERVEROUT ON SIZE 10000 
SET LINESIZE 250
Begin 
foo(A);
end; 
exit; 
EOF`
awk -F "," '$2=$RET_VALUE'  a.csv > b.csv
exit

awk -F "," -v value="$RET_VALUE" '$2=value'  a.csv > b.csv

OUTPUT=`sqlplus -s apps/apps@APPS <<EOF
set pages 0 lines 120 trimout on trimspool on tab off echo off verify off feed off serverout on
var mavar varchar2(100);
exec test_x(:mavar);
print mavar;
exit;
EOF`
 
echo "OUT = ${OUTPUT}"
awk -F "," -v value="${OUTPUT}" '$2=value'  a.csv > c.csv
exit

create or replace procedure test_proc (  i in varchar , j out varchar )
is
begin
j:='Outcome';
end;
/

#!/bin/sh
inp='Sample';
OUTPUT=`sqlplus -s saidata/saidata <<EOF
set pages 0 lines 120 trimout on trimspool on tab off echo off verify off feed off serverout on
var mavar varchar2(100);
exec test_proc ( '${inp}'  , :mavar);
print mavar;
exit;
EOF`