Home Man
Today's Posts

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

# 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 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
A crontab job not working JDBA SuSE 2 05-05-2014 08:17 AM
Crontab not working krebe Linux 4 02-12-2013 04:50 AM
crontab is not working!! getrue Red Hat 14 09-08-2011 11:06 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

All times are GMT -4. The time now is 07:12 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
Show Password