Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: long stored procedure, feedback to caller while running
"Andreas Mosmann" <keineemails_at_gmx.de> wrote in message
news:1128781189.8_at_user.newsoffice.de...
> Andreas Mosmann schrieb am 08.10.2005 in
> <1128776274.51_at_user.newsoffice.de>:
>
> Would be a crazy way but should work:
> <PSEUDOCODE>
> Application:
> Create Sequence XY
> (XY has to be uniqe, so I would use another sequence to generate
> this)
>
> Thread1:
> NewSession;
> Call procedure with Sequencename XY as parameter
> EndSession;
>
> Thread2:
> NewSession;
> NumberOfCalls:=0;
> while not finished Thread1 do
> ActualValue:=Sequence XY.NextVal;
> increment(NumberOfCalls);
> showmessage(ActualValue-NumberOfCalls+' records proceeded');
> loop while;
> EndSession;
>
> if finished Thread1:
> Drop sequence XY;
> <PSEUDOCODE>
>
> This way may work but looks strange to me. There must be a better way,
> isn't it?
>
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de
Look at v$sessionlongops. The user would have to query that.
Jim
Received on Sat Oct 08 2005 - 10:04:00 CDT