Skip to Main Content

Database Software

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.

[Database]Flow for event based job on secure queue

User_EF4YWJul 5 2019

Hi guys

Can you please help me identify what am I missing?

I'm trying to execute a dequeue procedure on arrival of a message(message has recipients) in a particular queue

Until now performed these tasks:

-create q1 (multiconsumer)

-add r1 as subscriber to q1

-enq in q1 with recipient r1

-event based job j1 with queue_spec='j1,r1' (job should execute the dequeue procedure )

problem is that job does not fire (tried also without specifying the agent name... only time that it fires is when the message is enqueued without any recipients, but dequeue fails because there is no consumer specified )

I seacrhed the internet for a concrete example how to create a event based job on enqueueing with recipients, but no luck

Is the flow ok? do I have to perfom something else?

May it be that I hit

Bug 9946875  Scheduler event-based job does not fire when there is a subscriber on AQ queue

Regards Florin

Comments

S VISHAL KUMAR

Is the space in the folder name mandatory ? Please change the folder name to single word or use _ in between and try again.

Thanks,

Vishal Kumar

S VISHAL KUMAR

Hello,

It seems, OATS requires that the installation directory does not contain any special characters and may be because of space it is not working as expected.

Thanks,

Vishal Kumar

1 - 2

Post Details

Added on Jul 5 2019
0 comments
143 views