node-oracledb Can't set recipient_list in the Advanced Queue

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

Dec 08 '20 07:12 MaximKokovin

Is this some JMS-ish queue?

Dec 08 '20 07:12 cjbj

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

Dec 08 '20 07:12 MaximKokovin

Details matter!

Dec 08 '20 08:12 cjbj

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

Dec 08 '20 08:12 MaximKokovin

As discussed on Slack, how was the queue created?

Dec 11 '20 01:12 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.

Jan 07 '21 22:01 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.

Oct 13 '21 03:10 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.

Aug 12 '22 07:08 cjbj

node-oracledb 5.5 contains this patch.

Sep 13 '22 06:09 cjbj