Shell Programming and Scripting

'ksh: sqlplus:  not found'

echo " hello world"
sqlplus -s apps/CAF78GEN<<EOF
          set heading off
          set feedback off
          set pagesize 0
          set linesize 32767
          VARIABLE l_object_type  VARCHAR2(20)
          VARIABLE l_last_ddl     VARCHAR2(50)
          VARIABLE l_owner        VARCHAR2(50)
             exec xxat_sox_proc('$file_name',:l_out_put,:l_change_flag);
          print l_ouput
          print l_change_flag
       exit
       EOF
echo "test hi"

ORACLE_HOME
ORACLE_SID
LD_LIBRARY_PATH (optional)

export ORACLE_something=whatever