Pro*C Update not working from Crontab


Login or Register 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.
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Crontab update ron5174 Shell Programming and Scripting 15 04-29-2018 05:03 PM
Crontab is not working BPANDEY Red Hat 5 09-17-2015 10:55 AM
Crontab not working Junaid Subhani Shell Programming and Scripting 7 06-06-2015 03:02 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, please help samantha13 UNIX for Advanced & Expert Users 0 08-02-2012 12:25 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 not working shifahim UNIX for Dummies Questions & Answers 8 08-16-2011 08:22 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
crontab not working rajesh_hv UNIX for Advanced & Expert Users 4 10-28-2008 07:45 AM
Unable to update the Crontab Jeremy3 Solaris 4 02-22-2007 06:02 AM
crontab not working right kymberm UNIX for Dummies Questions & Answers 3 07-09-2003 04:21 PM