#!/bin/bash
#------------------------------------------------------------------------------
#  source_me assumed to be a sh script
#------------------------------------------------------------------------------
if [ -f source_me ] ; then . source_me ; fi

query=$*

# echo query=$query

cat <<EOF >.tmp
set heading off;
set feedback off;
set pagesize 0;
set verify off;
$query ;
exit ;
EOF

sqlplus cdf_reader/reader@cdfofprd @.tmp | grep -vi oracle      | \
        grep -v JServer | grep -v SQL | grep -v "Connected to"  | \
        grep -v 'With the Partitioning and Data Mining options' | \
        awk '{if ($0 != "") print $0}'

rc=$?
if [ $rc == 0 ] ; then rm .tmp ; fi

exit $rc