in Oracle, how can we dequeue data conditionally in dbms_aq.dequeue
Use TABLE
and EXISTS
operators.
l_dequeue_options.deq_condition := 'EXISTS( SELECT 1 FROM TABLE(CAST(tab.user_data.line_varray AS SYSTEM.ASO_Line_Var_Type)) e WHERE e.org_id = 99)';