3 Replies Latest reply: Apr 28, 2014 9:48 PM by petra-K RSS

    What is wrong with my queue?

      Hi all,

       

      11.2.0.1

       

      I am creating a queue using:

       

      /* create queue */

      EXEC DBMS_AQADM.CREATE_QUEUE(

        queue_name => 'GREETINGQUEUE',

        queue_table => 'GREETINGQUEUETAB');

       

      ======

      SQL> EXEC DBMS_AQADM.CREATE_QUEUE(

        queue_name => 'GREETINGQUEUE',

        queue_table => 'GREETINGQUEUETAB');BEGIN DBMS_AQADM.CREATE_QUEUE(; END;

       

       

                                    *

      ERROR at line 1:

      ORA-06550: line 1, column 31:

      PLS-00103: Encountered the symbol ";" when expecting one of the following:

      ( ) - + case mod new not null <an identifier>

      <a double-quoted delimited-identifier> <a bind variable>

      table continue avg count current exists max min prior sql

      stddev sum variance execute multiset the both leading

      trailing forall merge year month day hour minute second

      timezone_hour timezone_minute timezone_region timezone_abbr

      time timestamp interval date

      <a string literal with character set specification>

       

       

       

      Please helpppp....

       

      Thanks,

      pK