PL/SQL (MOSC)

MOSC Banner

ORA-00922: missing or invalid option

edited Feb 21, 2011 9:12AM in PL/SQL (MOSC) 10 commentsAnswered
 Hello all,
      I think this is the most suitable community to post my question.
I've a problem creating a structure of queue tables.

The error is:

     ORA-00922: missing or invalid option

And the script is:

     DECLARE
        subscribers sys.aq$_agent;
     BEGIN
        subscribers := sys.aq$_agent ('subscriber1', null, null);
       DBMS_AQADM.CREATE_QUEUE_TABLE (Queue_table => 'JMS_EVENTOS', Queue_payload_type => 'SYS.AQ$_JMS_TEXT_MESSAGE', multiple_consumers=>true);
       DBMS_AQADM.CREATE_QUEUE (Queue_name => 'JMS_COLA_EVENTOS', Queue_table => 'JMS_EVENTOS');
       DBMS_AQADM.add_subscriber(queue_name=> 'JMS_COLA_EVENTOS', subscriber =>subscribers);
       DBMS_AQADM.START_QUEUE (Queue_name => 'JMS_COLA_EVENTOS');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center