Skip to Main Content

Integration

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Call longer running Oracle pl/sql procedures from Oracle Integration using ATP adapter

Sowmya SowmyaJan 25 2025

I am an Oracle Integration Cloud (OIC) developer facing challenges with long-running PL/SQL procedures timing out. To mitigate this, I am considering using DBMS_SCHEDULER to execute these procedures asynchronously, allowing OIC to regain control promptly.

I would appreciate insights on the potential maintenance overhead associated with this approach, particularly regarding:

  1. Effective job management and monitoring
  2. Resource allocation and its impact on database performance
  3. Strategies to handle maintenance windows and avoid conflicts
  4. Security considerations and privilege management
  5. Best practices for logging and auditing scheduled jobs
  6. How has been your experience with this approach?

Any advice or experiences shared would be greatly appreciated.

Thank you!

Comments

Post Details

Added on Jan 25 2025
0 comments
81 views