Re: How to display the progress of a long running pl/sql procedure(installed on the database) within forms

G.Reulen wrote:
>
> How to display the progress of a long running pl/sql procedure(installed on
> the database) within forms
>
> I have a pl/sql procedure installed on the database.
> When starting this pl/sql procedure from within forms (5) i want to display
> the progress of this procedure.
> How can I do this?
>
> Thanks
>
> Guido Reulen

Some options:

1. Break the code into several components so that you can update the status at the completion of each component.
2. Use dbms_job to submit it as a background task, and record status in client_info in V$session using dbms_application_info (which you can then query from Forms)

Either are a bit of a pain to implement...

HTH

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."