Re: long stored procedure, feedback to caller while running

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 08 Oct 2005 15:41:57 GMT
Message-ID: <Xns96E95882D9F4ASunnySD@68.6.19.6>

Andreas Mosmann <keineemails_at_gmx.de> wrote in 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
>

One possibility would be to have the application populate the CLIENT_INFO field of V$SESSION; which could be queried from another session. Received on Sat Oct 08 2005 - 10:41:57 CDT