feedback fro oracle stored procedure

[Hans Nieuwenhuis]

Hi,

I have some Oracle stored procedures that may run for 10 or 20 seconds.
I want to give the user feedback.

I am thinking about the following scenario :

- The stored procedure writes it's progress to a field in a progres table.
- show this table/field in the form from which the stored procedure is started .

But how can I do a refresRecordFromDatabase whilst the stored procedure is running ?

- start a cronjob before starting the stored procedure and do the resfresh every few seconds ?

- or ????

Or is there a better scenario to achieve this ??

Regards,

[pbakker]

As the Servoy Client is single threaded, whatever way you kick off the stored procedure doesn't matter: the UI will be blocked until the sp is done.

Only option would be to offload the execution of the sp to a other client, for example a headless client. Once you do that, the technique you contemplating to use to give the user feedback will work just fine.

Paul

[Hans Nieuwenhuis]

Hi paul,

In the last few days I did just that. ( using a headless client )

Works excellent !!!

Regards,