You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OOTB Capability in OIC to Execute Long-Running PL/SQL Procedures without relying on DBMS_SCHEDULER

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):


Description (Required):

In many business scenarios, integrations require the execution of long-running PL/SQL procedures within Oracle database. Currently, these use cases are managed through custom wrappers, polling patterns, or DBMS_SCHEDULER-based workarounds, which add complexity and operational overhead.

An out-of-the-box feature in OIC that enables safe and efficient execution of long-running PL/SQL procedures - directly  without relying on DBMS_SCHEDULER or custom workarounds would greatly simplify such implementations. A capability similar to SaaS callbacks or a configurable timeout mechanism would be highly beneficial.

1 votes

Submitted · Last Updated

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!