👤
Home Man
Search
Today's Posts
Register

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
# 1  
Old 09-13-2007
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
# 2  
Old 09-13-2007
Sounds like the problem of 99% of cron jobs, not having the environment set up.
# 3  
Old 09-16-2007
Any Suggustion

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

« Previous Thread | Next Thread »
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 update ron5174 Shell Programming and Scripting 15 04-29-2018 05:03 PM
Crontab not working krebe Linux 4 02-12-2013 04:50 AM
Pro*c binary file is not working Akhirul HP-UX 10 12-11-2012 04:21 PM
crontab not working isaacniu Solaris 6 01-09-2012 05:41 PM
crontab is not working!! getrue Red Hat 14 09-08-2011 11:06 AM
crontab is not working. getrue Solaris 6 07-27-2011 12:34 AM
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


All times are GMT -4. The time now is 02:20 AM.



All times are GMT -4. The time now is 02:20 AM.

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