Subscription for Advanced Queuing Multiconsumer

[gallifge]

Good morning all,
I apologize if it's an already previous discussion, I tried to search but I didn't find anything.
As per title, we're using some queues multiconsumer and we're not able to use the connection.subscribe since it seems it's not possible to specify in any way the consumerName. Am I wrong?
Thank you in advance and regards

[sharadraju]

Hi,
You can set consumerName in the deqOptions attribute (https://node-oracledb.readthedocs.io/en/latest/api_manual/aq.html#aqQueue.deqOptions)
consumerName attribute can be set as part of the recipient lists in AQ. See https://node-oracledb.readthedocs.io/en/latest/user_guide/aq.html#recipient-lists

Can you please let us know your Oracle Database version, node-oracledb version?
Are you using Thin mode or Thick mode? AQ is supported in Thin mode from node-oracledb 6.10 onwards.

Can you elaborate a bit more on the use case?

[gallifge]

We're using Oracle Express 18 and node oracledb 6.10.0 in thick mode (the only way to use also Continuous Query Notification).
I know that for dequeuing a message I can can set the consumerName in deqOptions, it works.
I'm asking regarding the method connection.subscribe that can be used also for subscribe notifications regarding a queue (using the subscribe(): options Parameter Properties, namespace --> You can use oracledb.SUBSCR_NAMESPACE_AQ to get notifications that Advanced Queuing messages are available to be dequeued, see Advanced Queuing Notifications
With a multiconsumer queue this method returns error ORA-25257.