Re: Proc Exceptional Behaviour.........

sunil wrote:
> Thanks for replying.
> I have checked the code and the logs . But nothing exceptional. And i
> don't find any logic why it runs after submitting it once.
>
>
>
> Laurenz Albe wrote:
> > spsingh.sunil_at_gmail.com wrote:
> > > My project has some part of its code written in Pro C. The problem i am
> > > facing is that some times the job which internally uses oracle gives
> > > exception but when the same job is resubmitted the same things work.
> > > Secondly this too happens like onve in blue mooon. Can any body suggest
> > > some good ideas to solve this problem.

What was the exception code? You said it gives an Oracle Exception when it fails, so there has to be something in the logs.

Another gotcha in ProC, besides the ones mentioned, is the scoping rule dicodomy between C and embedded SQL. Declaring and exception handler in one function, carries over to the next function. This can cause runtime errors.

But still, we cannot help unless you provide the error. What was it?

   Ed Received on Thu Aug 03 2006 - 23:42:12 CEST