| Embedded SQL in C- run by Job - problems [message #170644] |
Thu, 04 May 2006 10:38  |
SaraC
Messages: 81
Registered: August 2005
|
Member |
|
|
Ok will try and explain best I can - sorry if this is not the right forum/section.
I have a proC program that has embedded SQL to retrieve data from an oracle database.
The query is run by a C batch process - picks up "jobs" from our Oracle Job table. when we run the query via the job once i.e. an individual job it works retrieves the data fine. But when we try to make the job repeating - the query doesn't run - it could have something to do with locking the table - but not sure and dont know much about locks. Repeating jobs place another waiting job into the table automatically so it keeps repeating...
runs fine until the Embedded FETCH statment then stops dead no oracle errors or c errors
Any ideas appreciated - been looking at this for days - or even suggestion on other places /forums to post that might help.
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
