Home » SQL & PL/SQL » SQL & PL/SQL » Randomly failing procedure
Randomly failing procedure [message #265406] Thu, 06 September 2007 04:53 Go to next message
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
Re: Randomly failing procedure [message #265407 is a reply to message #265406] Thu, 06 September 2007 04:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:

There is an explicit cursor opened in it, but not explicitly closed.


Is there any reason to make it open?
Re: Randomly failing procedure [message #265411 is a reply to message #265406] Thu, 06 September 2007 04:59 Go to previous messageGo to next message
gvranjith
Messages: 3
Registered: August 2007
Junior Member
for performing required operation, cursor was opened.

It was not closed....

thats all
Re: Randomly failing procedure [message #265413 is a reply to message #265411] Thu, 06 September 2007 05:00 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Why don't you at least post the error message?

Ross Leishman
Re: Randomly failing procedure [message #265414 is a reply to message #265406] Thu, 06 September 2007 05:01 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Can't you please close it? Do you know whats the effect of remaining opening a cursor?
Previous Topic: regarding index & partition.
Next Topic: better way of string parsing?
Goto Forum:
  


Current Time: Thu Feb 13 16:31:04 CST 2025