My Oracle Support Banner

How To Use A Dynamic Argument in DBMS_SCHEDULER (Doc ID 2871136.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Need to have a way to use a dynamic argument (e.g. SYSDATE) for a JOB program.
However, the DBMS_SCHEDULER.SET_JOB_ANYDATA_VALUE procedure does not dynamically change the argument value.
It always uses fixed value, regardless of when the job is run.
How can I use a dynamic value in the JOB?




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.