Re: Blocking stored procedure leaves an opened session

YuliaG wrote:

> Hi Everyone,
> Please, help me resolving the following problem:
> I have a blocking stored procedure that runs on the database (waits
> for new entries on Advanced Queue) and leaves an opened session even
> if the owner thread exits.Please, tell me how I can configure my
> database to return from this stored procedure if no message arrives
> (DBMS_AQ.ENQUEUE action) in a specified time.
> Thanks a lot for your reply,
> Yulia

Check SYSDATE in the loop and time-out.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)