Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Infinite loop

770548Mar 30 2011 — edited Mar 31 2011
Hi,
I've designed a pl/sql procedure which, apparently, works fine. I've planned a job with the dbms_scheduler to run it everyday at the same time. My problem is that sometimes the job finish without problems (it takes two hours and half to finish) and sometimes it seems as if the job enters is infinite loop.

Is there any way (or tool) of knowing why it fails?

Thanks in advance.
Regards.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2011
Added on Mar 30 2011
12 comments
203 views