Can't set recipient_list in the Advanced Queue

[MaximKokovin]

Hi! I'm using node-oracle 4.2.0 version.

I'm trying put the message in the queue using .enqOne() method. But oracle return error (Error: ORA-24033: no recipients for message). How can i set recipients for my message?

https://gist.github.com/MaximKokovin/2c4cceaaedc43a2fb1f1e1f27c6eaaaf

This sql-script add message to the queue
https://gist.github.com/MaximKokovin/28462546ccb72555ef5eb3750c371c6e

[cjbj]

Is this some JMS-ish queue?

[MaximKokovin]

i think no but i don't sure. This is oracle advanced queue (pl/sql).

[cjbj]

Details matter!

[MaximKokovin]

@cjbj i don't use JMS queue, only advanced queuing (AQ).

[cjbj]

As discussed on Slack, how was the queue created?

[cjbj]

Marking as an enhancement so this doesn't get auto closed without investigation. It's not clear if driver changes can or need to be made, but I'd like to know.

[cjbj]

An update: the AQ team have looked at this. Some driver layer changes would be needed. I'll leave this open until they can be scheduled.

[cjbj]

Support for this was just merged to the main branch. See https://oracle.github.io/node-oracledb/INSTALL.html#githubtags for how to build it.

[cjbj]

node-oracledb 5.5 contains this patch.