| Oracle® Objects for OLE Developer's Guide 11g Release 2 (11.2) for Microsoft Windows Part Number E17727-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
Applicable only for a dequeue operation.
Q.Consumer = consumer_name 
String
The value is a string representing the name of the consumer. Only those messages matching the consumer name are accessed.
Dim DB As OraDatabase 
    Dim Q as OraAQ 
      set Q = DB.CreateAQ("Q_MSG_MULTIPLE") 
      'Dequeue only message meant for ANDY 
       Q.consumer = "ANDY" 
      'other processing...  
       Q.Dequeue