Same Queue with Multiple Payloads [message #461860] |
Mon, 21 June 2010 23:59 |
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 |
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 |
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
|
|
|
|