PL/SQL (MOSC)

MOSC Banner

Using Advanced Queues to pass a payload to a Scheduled Job argument

edited Jun 20, 2020 10:41PM in PL/SQL (MOSC) 2 commentsAnswered

I can use AQ to trigger the execution of a Scheduled Job, and I can use AQ to pass data to a stored procedure, but is there any way to do both at the same time? In other words, can AQ both trigger a job and pass the data payload on to that job as arguments for a Scheduler Program? I have searched the documentation and several blogs and forums and not found any answer. Must I therefore use two queues - one to trigger the job and the other to pass data to the procedure executed by the job?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center