Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Query timeout

Query timeout

From: ReplyToGroups <sorry_at_NoAddress.com>
Date: Fri, 21 Nov 2003 07:58:21 -0500
Message-ID: <bpl25e$4jj2@eccws12.dearborn.ford.com>


Hi

Is there anyway I can break the long running query after 'x' minutes. I wanted to do this in procedure.
Let's say if the query runs more than 2 minutes then I wanted to Exit the procedure and send the message to the user.

Thanks
Sync Received on Fri Nov 21 2003 - 06:58:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US