Home » Server Options » Streams & AQ » Same Queue with Multiple Payloads (Oracle 10g)
Same Queue with Multiple Payloads [message #461860] Mon, 21 June 2010 23:59 Go to next message
test_usr1
Messages: 7
Registered: March 2010
Junior Member
Hi,

I have an existing queue with a specific payload .
Now the upstream system wants to send different requests but they want us to use same queue and identify with difference in nrrot nodes. As previous request was xml type , new will be html sort
Please guide how it can be done

Thanks
Re: Same Queue with Multiple Payloads [message #461869 is a reply to message #461860] Tue, 22 June 2010 00:51 Go to previous messageGo to next message
test_usr1
Messages: 7
Registered: March 2010
Junior Member
please guide as i tried to give more than one payload to same queue table . it gave error


begin

     DBMS_AQADM.create_queue_table (
    queue_table            =>  'test_Q_TAB',
    queue_payload_type     =>  'OBJ2',
    queue_payload_type     =>  'OBJ1',
    multiple_consumers => TRUE);
    Exception
 When others then
 dbms_output.put_line('Error :'||sqlerrm);
  End;

ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00703: multiple instances of named argument in list
ORA-06550: line 2, column 6:
PL/SQL: Statement ignored


please advise
Re: Same Queue with Multiple Payloads [message #473880 is a reply to message #461869] Wed, 01 September 2010 06:48 Go to previous messageGo to next message
shamimdba11
Messages: 1
Registered: September 2010
Location: delhi
Junior Member
hi all

i joined new company, the last dba implemented the oracle queue. now i do not have any document regrading oracle queue.
please help me to check that the oracle queue is working fine or not or health checkup of oracle queue.

Please help me

thanks
shamim akhtar
Re: Same Queue with Multiple Payloads [message #473891 is a reply to message #473880] Wed, 01 September 2010 08:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have you somewhere and some form then data you input in the queue?
Is someone complainng that something is missing?

Regards
Michel
Previous Topic: Oracle streams with 10g source & 11g target
Next Topic: Initial data synchronization
Goto Forum:
  


Current Time: Thu Mar 28 18:45:51 CDT 2024