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!

Ending an oracle process

Nalla (Nallasivam)Jan 19 2009 — edited Jan 20 2009

Hi All,

Is there a way to end the execution of a procedure, if it is going to run over 10 mins ?

I'm executing a procedure, most of the times it takes 2 - 3 mins. Sometimes it takes like 10+ mins. I want to move the process into exception if it is running more than 10 mins ...

Is there any way ... Please thro' some light.

thanks in advance !

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2009

Added on Jan 19 2009

4 comments

397 views