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 -> Blocking stored procedure leaves an opened session

Blocking stored procedure leaves an opened session

From: YuliaG <yuliag_at_tecnomatix.com>
Date: 19 Jan 2004 00:26:36 -0800
Message-ID: <7f891490.0401190026.3d2517e7@posting.google.com> 





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
Received on Mon Jan 19 2004 - 02:26:36 CST












Original text of this message













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