Randomly failing procedure [message #265406] |
Thu, 06 September 2007 04:53  |
gvranjith
Messages: 3 Registered: August 2007
|
Junior Member |
|
|
I have a PL/SQL procedure which i need to run more than 100 times a day, which is scheduled.
Many a time it completes succesfully, but once a while it fails randomly.
I tried to capture exception if any, but there were no exceptions.
There is an explicit cursor opened in it, but not explicitly closed.
Is there any relation with explicit cursor and the procedure erroring out.
Can any one please give some info on this.
Ranjith
|
|
|
|
|
|
|