Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Blocking Stored Procedure leaves an opened session
Hi Everyone,
Please, help me resolving the following problem:
I have a blocking stored procedure that runs on the database (waits
for new entries in 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
Received on Sun Jan 18 2004 - 11:15:39 CST