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.