UNIX for Advanced & Expert Users

Expert-to-Expert. Learn advanced UNIX, UNIX commands, Linux, Operating Systems, System Administration, Programming, Shell, Shell Scripts, Solaris, Linux, HP-UX, AIX, OS X, BSD.

Pro*C Update not working from Crontab

👤 Login to reply

 
Thread Tools Search this Thread Display Modes
    #1  
Old 09-13-2007
alhallay alhallay is offline
Registered User
 
Join Date: Sep 2007
Last Activity: 17 September 2007, 1:08 AM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Data Pro*C Update not working from Crontab

Dear All,

I have writen a Pro*c program that does a data base select,insert,update statements and I have scheduled the program to run from crontab,

It is runing fine for the select insert and commit statement till it reaches the update statement , it throws the following error:

SQL On IPB Account 239907203 - Bill 2411212954

Oracle error, sqlstate is

Error occured. sqlcode = -3114
message = ORA-03114: not connected to ORACLE

Last SQL statement: update ipb_fix_batch_err_t e set e.STATUS=3,e.e_date=:b0 where (e.bil

At or near line number 2096

Cursor Cache Statistics
------------------------
Maximum value of MAXOPENCURSORS: 10
Maximum open cursors required: 10
Current number of open cursors: 10
Number of cache reassignments: 7
Number of SQL statement parses: 17
Number of SQL statement executions: 21

If I run the program from the command line it runs fine,

Please can any one help me in this, it is so urgent

Thanks
Sponsored Links
    #2  
Old 09-13-2007
porter porter is offline Forum Advisor  
Registered User
 
Join Date: Jan 2007
Last Activity: 8 January 2008, 6:50 PM EST
Posts: 2,965
Thanks: 0
Thanked 5 Times in 5 Posts
Sounds like the problem of 99% of cron jobs, not having the environment set up.
Sponsored Links
    #3  
Old 09-16-2007
alhallay alhallay is offline
Registered User
 
Join Date: Sep 2007
Last Activity: 17 September 2007, 1:08 AM EDT
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Any Suggustion

Any suggestion which environment variable may be missing?
Sponsored Links
👤 Login to reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
crontab not working isaacniu Solaris 6 01-09-2012 05:41 PM
crontab not working lg123 UNIX for Dummies Questions & Answers 2 04-24-2011 03:47 PM
Unable to update the Crontab Jeremy3 Solaris 4 02-22-2007 06:02 AM
crontab NOT working baanprog UNIX for Advanced & Expert Users 2 09-26-2006 12:11 PM
crontab not working right kymberm UNIX for Dummies Questions & Answers 3 07-09-2003 04:21 PM



All times are GMT -4. The time now is 11:48 PM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
×
UNIX.COM Login
Username:
Password:  
Show Password





Not a Forum Member?
Forgot Password?