search

oracle / node-oracledb

Oracle Database driver for Node.js maintained by Oracle Corp.
http://oracle.github.io/node-oracledb/
Other
2.25k stars 1.07k forks source link

Can't set recipient_list in the Advanced Queue #1326

Closed MaximKokovin closed 2 years ago

MaximKokovin commented 3 years ago

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 commented 3 years ago

Is this some JMS-ish queue?

MaximKokovin commented 3 years ago

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

cjbj commented 3 years ago

Details matter!

MaximKokovin commented 3 years ago

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

cjbj commented 3 years ago

As discussed on Slack, how was the queue created?

cjbj commented 3 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

node-oracledb 5.5 contains this patch.