Skip to Main Content

APEX

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!

Static ID and Automation_ID as bind variables in APEX Automations

Jon FinkeApr 23 2025

Using APEX Automations in 23.1. I need to tie these into my regular job monitoring and logging world. While I can periodically scan the log tables, I would like to grab stuff from the Automation definition.

At the moment, I am adding a call to the Initialization Procedure:

But at the moment, I have to hard code the static id of the automation into the call. It would be nice there were a BIND variable I could use, or alternately a function call in the APEX_Automations package. Likewise I would like to grab the Automation Log ID, so my external processes could go in search for the completion of THIS run, as well as the messages it generates. Again, this could be a bind variable or function call.

This post has been answered by Carsten Czarski-Oracle on Apr 24 2025
Jump to Answer
Comments
Post Details
Added on Apr 23 2025
2 comments
574 views