Shell Programming and Scripting

#!/bin/bash
input="some data"
output=$(
  sqlplus -s username/passwd@dbname <<EOF
  set serverout on size 1000000
  set feedback off
  DECLARE
     dbms_output.enable(1000000);
     local_input varchar2(256):="$input";
     local_output varchar2(256):=NULL;
  BEGIN
     foo(local_input, local_output);
     dbms_output.print_line(local_output);
  END;
/
EOF
)

#!/bin/sh
value=`sqlplus -S $username/$password@$tnsname @/loc/temp.sql << EOF`
echo $value
if [ $value -gt 0 ]
then
echo "value is Greater"
done

set pages 0
set trimspool on
set serveroutput off
set echo off
set feedback off
set heading off
variable out NUMBER
begin
        pack.proc(:out);
end;
/
print :out
exit;

#!/bin/sh
value=`sqlplus -S $username/$password@$tnsname @/loc/temp.sql << EOF`
echo $value
if [ $value -gt 0 ]
then
  echo "value is Greater"
done

value=`sqlplus -S $username/$password@$tnsname @/loc/temp.sql`

desc dbms_output
-- if this fails try:
desc sys.dbms_output