1 Reply Latest reply: Feb 9, 2013 1:53 PM by Vincent Rogier RSS

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

    985490
      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.