Pro*C Update not working from Crontab


Login or Register for Dates, Times and 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

Thanks
# 2  
Sounds like the problem of 99% of cron jobs, not having the environment set up.
# 3  
Any Suggustion

Any suggestion which environment variable may be missing?
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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 ...... (15 Replies)
Discussion started by: ron5174
15 Replies

2. Shell Programming and Scripting

Crontab not working

Hi All, I have a script with deatils as : $ ls -ld catch_logs.sh -rwx--x--x 1 muser muser 752 Jun 5 22:36 catch_logs.sh User crontab looks likes: $ crontab -l SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin * * * * * /opt/scripts/catch_logs.sh Now if I run this script... (7 Replies)
Discussion started by: Junaid Subhani
7 Replies

3. Linux

Crontab not working

Hi, I know this is a common topic. I'm trying to launch a perl script using a contab -e entry. I've been trying diff options but nothing seems to work: My cron is running: UID PID PPID C STIME TTY TIME CMD root 3755 1 0 Nov27 ? 00:00:00 crond This... (4 Replies)
Discussion started by: krebe
4 Replies

4. HP-UX

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... (10 Replies)
Discussion started by: Akhirul
10 Replies

5. Solaris

crontab not working

Shell = ksh Hi all, I scheduled an automated job on my application server like below, 30 13 * * 1-5 $HOME/my_script.sh However the script was not executed as expected. Any reason that may cause this to happen? (6 Replies)
Discussion started by: isaacniu
6 Replies

6. UNIX for Dummies Questions & Answers

crontab not working

In /oracle folder, I created a file called "script.ksh" using vi command. The content of script.ksh is * * * * * echo "welcome">/tmp/capture.log I want the word "welcome" to be displayed in /tmp/capture.log file every minute. I have created capture.log under /tmp folder. Then in... (2 Replies)
Discussion started by: lg123
2 Replies

7. UNIX for Advanced & Expert Users

crontab not working

Dear all We have SunOS 5.10 Generic_127127-11 sun4u sparc SUNW,Sun-Fire-V250 i have scheduled cronjob but its not working Crontab details 15 15 * * * /d5/oratest/testdb/hotbackup_new.sh TEST247 15 15 * * * mkdir -p rajesh /d4/appltest Crontab log details > CMD: mkdir... (4 Replies)
Discussion started by: rajesh_hv
4 Replies

8. Solaris

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... (4 Replies)
Discussion started by: Jeremy3
4 Replies

9. UNIX for Dummies Questions & Answers

crontab not working right

I am having problems with a sparc5 solaris 7 box, when i try to edit cron, (crontab -e as root), it says $ crontab -e 0 and then nothing, if i enter anything it errors out but does accept q for quit. But doesn't bring up my editor of the cron file. How can I troubleshoot this? ... (3 Replies)
Discussion started by: kymberm
3 Replies

Featured Tech Videos