Skip to Main Content

E-Business Suite

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!

Is there any API or Function to add a delay in the procedure call type data set?

User_F1CR8Apr 6 2023 — edited Apr 6 2023

In the BI Publisher Reports, I have a data model with SQL query data set that is of procedure call type.

It is used to trigger many ESS jobs.

I want to add a delay between some ESS job calls.

Is there any PL/SQL API or Function available to add a delay/sleep kinda mechanism?

Comments
Post Details
Added on Apr 6 2023
0 comments
396 views