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

Home -> Community -> Usenet -> c.d.o.misc -> long stored procedure, feedback to caller while running

long stored procedure, feedback to caller while running

From: Andreas Mosmann <keineemails_at_gmx.de>
Date: Sat, 08 Oct 2005 14:57:54 +0200
Message-ID: <1128776274.51@user.newsoffice.de> 





Hi NG,



I created a PL/SQL- procedure that takes some time (about 10 minutes).
Now I would like to inform the user about progress (like "10.000 Lines 
proceeded").


The PL/SQL- procedure is called via a Direct-Access-Component (ODAC by 
CoreLab).


Is there a way to give the caller a feedback? If I am informed correct 
there is no way to use dbms_output for this. Any other ways?



Thanks in advance


Andreas


-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de


Received on Sat Oct 08 2005 - 07:57:54 CDT












Original text of this message













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