can't run sql script inside ksh script

From: Masha Gurenich <gurenich_at_gmail.com>
Date: Thu, 19 Nov 2009 17:11:09 -0500
Message-ID: <ebb6b7320911191411t22f4096fi884f0fe53ffd6e1d_at_mail.gmail.com>



Hi all,

This one just drives me nuts..
I have a shell script that works OK while I am running it manually. It runs OK via cron up to the point where sql script should be executed:

<<<bla-bla>>>

/u01/app/sghe/dw/dwprod/app/scripts/dapstart
/u01/app/sghe/dw/dwprod/app/scripts/webstart

/u01/app/oracle/product/bin/sqlplus

dwmgr/u_pick_it_at_pds1_PURPLE_at_/home/dwadmin/scripts/bannerstudents.sql <<SQLPLUS
exit
SQLPLUS the bannerstudents.sql is not being executed.. this is what i see in log file:

<<<bla-bla>>>

  • DegreeWorks Web Message Queue: Key: 513 = 0x201 ===== MsgQ Key MsgId Owner Perms #Bytes #Msgs 0x00000201 2326529 dwadmin 666 0 0

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 19 15:13:08 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

~

that's it!! it connects to sqlplus, but doesn't execute the script. WHY??? Please, help me. I have tons of scripts like that and all of them are working. what is wrong with that one??

thanks beforehand,
M

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 19 2009 - 16:11:09 CST

Original text of this message