Home » SQL & PL/SQL » SQL & PL/SQL » help with dbms_aqadm package
help with dbms_aqadm package [message #207477] Tue, 05 December 2006 13:43 Go to next message
spilab
Messages: 2
Registered: December 2006
Location: nyc
Junior Member
Hey all,

Wondering is someone would be kind enough to help me out here. Trying to execute an aq package to create queue tables, and consistently get the same error:

SQL>
SQL> BEGIN
2 DBMS_AQADM.CREATE_QUEUE_TABLE(
3 QUEUE_TABLE => 'AQ_ADMIN.TRANSIN_QUEUE_TBL',
4 MULTIPLE_CONSUMERS => 'FALSE',
5 SORT_LIST => 'ENQ_TIME',
6 QUEUE_PAYLOAD_TYPE => 'AQ_ADMIN.TRANS_MSG_TYPE',
7 compatible => '9.0.0',
8 comment => 'CREATED TRANSIN_QUEUE_TBL');
9 END;
10 /
DBMS_AQADM.CREATE_QUEUE_TABLE(
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00306: wrong number or types of arguments in call to 'CREATE_QUEUE_TABLE'
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored


Just a tad frustrated with this since it seems so simplistic. I know I'm missing something obivious; starting to get that "duh" feeling...


Any help would be greatly appreciated.
Thanks,

B
Re: help with dbms_aqadm package [message #207479 is a reply to message #207477] Tue, 05 December 2006 13:56 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member


[Updated on: Tue, 05 December 2006 13:56]

Report message to a moderator

Re: help with dbms_aqadm package [message #207551 is a reply to message #207477] Wed, 06 December 2006 00:25 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You have to provide a queue_name

[Edit: sorry, skip that. I was looking at the wrong procedure..]

Multiple_consumers is a boolean, not a string, so remove the quotes surrounding FALSE

[Updated on: Wed, 06 December 2006 00:27]

Report message to a moderator

Re: help with dbms_aqadm package [message #208197 is a reply to message #207477] Fri, 08 December 2006 09:46 Go to previous message
spilab
Messages: 2
Registered: December 2006
Location: nyc
Junior Member
Frank,

Thank you so much... I should have picked that up but sometimes ya can't see the forest for the trees! Major 'duh' on my part.

again, thanks
Previous Topic: substr truncates one byte
Next Topic: Checking date lag and merging several records into one
Goto Forum:
  


Current Time: Sun Dec 11 06:04:44 CST 2016

Total time taken to generate the page: 0.04531 seconds