Java Monitoring the Progress of a Long Running Stored Procedure
Hi All,
I'm not sure if this is exact forum.
I have problem related to Java application.
Here is the situation. There is a desktop application which is calling Oracle stored procedure. This procedure is generating reports with data from DB.
Everything is working fine, but for some of the reports procedure is running for long time.
I want to show the progress of procedure to the user.
I've googled around and found some kind of solution
1. When running PLSQL procedure inserts (updates) field of a table.
2. Java is querying that table at some interval and displays the results.
Did anybody has similar problem and what did you do?
What is the best approach ?
Thanks.