Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling PL/SQL Stored Procedure in ADF Application

1011931Mar 30 2017 — edited Mar 31 2017

Hi,

I have a button in my page.And it calls stored procedure which does some calculation. But It takes 30 minutes to finish the job.

In this case user gets timeout errors.I don't want to keep the user waiting. User can check the result 30 min later. Should I use dbms_job for this procedure ?

Do you have any suggestions?

Thanks

This post has been answered by jflack on Mar 30 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2017
Added on Mar 30 2017
4 comments
1,761 views