RE: can't run sql script inside ksh script
Date: Sun, 6 Dec 2009 22:21:27 -0500
You can either execute script from sql+ cmd line with _at_ or use ksh here-doc syntax. You're doing both at the same time. The later will over-ride and you will get nothing.
- sqlplus user/pwd_at_db @my-script Or
- Sqlplus .../..._at_db <<! _at_my-script exit !
From: Masha Gurenich <gurenich_at_gmail.com> Sent: Thursday, November 19, 2009 5:11 PM To: Oracle L <oracle-l_at_freelists.org> Subject: can't run sql script inside ksh script
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:
SQLPLUS the bannerstudents.sql is not being executed.. this is what i see in log file:
- 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.
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??