This discussion is archived
1 Reply Latest reply: Feb 9, 2013 11:53 AM by Vincent Rogier RSS

PL-SQL option named dequeue_options.deq_condition, corresponding OCI attrib

985490 Newbie
Currently Being Moderated
Hi All,
I am stuck with a problem. To dequeue the message from Oracle AQ in non-FIFO mode, we use dequeue_options.deq_condition option in PL/SQL. But i need to know the corresponding API attribute in OCI to set.
Like we do
OCIAttrSet(deqopt, OCI_DTYPE_AQDEQ_OPTIONS, (dvoid *)"SUBSCRIBER", strlen("SUBSCRIBER"), OCI_ATTR_CONSUMER_NAME, errhp)); to set the Subscriber name.
Same way what is the attribute to set for dequeue_options.deq_condition.

Thanks in advance.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points