Pro*C Update not working from Crontab

Login or Register to Reply

Thread Tools Search this Thread
# 1  
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  
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
Hello. We have a big crontab file where we need to comment out for few countries and also uncomment out based on situations . Could someone let us know how this can be done using a script . Sample file look like & here i need to comment/uncomment based on country code . 0-59 ......... Shell Programming and Scripting
Shell Programming and Scripting
Pro*c binary file is not working
Hi, I have written a sample pro*c code and able compile and create a executable file without any error. But I have to run this binary in some other server by FTPing this binary to other server. The directory structure of ORACLE_HOME for both server is different. I used ORACLE_HOME as...... HP-UX
Unable to update the Crontab
Hi Everyone, Each time I do update the crontab, it gets reset after exiting from the telnet session. I'm using Solaris 2.8 So it goes like this: Step 1: Login as root, from a telnet session Step 2: Crontab -e (I make modification) Step 3: Save and exit Step 4: Type crontab -l , changes...... Solaris
crontab NOT working
Hi, I have put the following entry in crontab and it is NOT working 1 * * * * && /mybin/ As today is Sep 26th, Iam using NF-4 to test. Thanks... UNIX for Advanced & Expert Users
UNIX for Advanced & Expert Users