Re: How to show progress of stored procedure executing ?

Karlis Ogsts wrote:
>
> Hi !
>
> I'm working on project in Oracle and have following problem:
> From Oracle Forms i call some complicated stored procedure.
> It executes slowly and very long. But i want to see how mutch is
> already done in any moment of time....For example i would like to see
> message:
>
> "342 of 3845 record processed"
>
> How can i do this?
> Maybe You can give me some advice?
> Thanks.Hello,

the only way i can think of is declaring a table (or a database-pipe?) where you write your progres in. Then you can periodically read this table (something like 'dual') by using a timed trigger in your form.

I saw a demo from oracle corporation some time ago incorporating such a method....

good luck !! Received on Thu Oct 24 1996 - 00:00:00 CEST