Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_AQ

DBMS_AQ

From: jyu <JoyceYu2048_at_gmail.com>
Date: 10 Feb 2005 07:00:05 -0800
Message-ID: <1108047605.277371.320100@c13g2000cwb.googlegroups.com>


I am trying some sample about oracle AQ. But I run into some trouble. When I try to create a procedure in SQLPLUS using the following script:

CREATE OR REPLACE PROCEDURE New_enqueue(

               Queue_name      IN VARCHAR2,
               Payload         IN RAW ,
               Correlation     IN VARCHAR2 := NULL,
               Exception_queue IN VARCHAR2 := NULL)
AS
Enq_ct     DBMS_AQ.Enqueue_options_t;
Msg_prop   DBMS_AQ.Message_properties_t;
Enq_msgid  RAW(16);

Userdata RAW(1000);

BEGIN
   Msg_prop.Exception_queue := Exception_queue;    Msg_prop.Correlation := Correlation;
   Userdata := Payload;

DBMS_AQ.ENQUEUE(Queue_name, Enq_ct, Msg_prop, Userdata, Enq_msgid); END;
/

It gave me these errors:

8/12     PLS-00201: identifier 'DBMS_AQ' must be declared
8/12     PL/SQL: Item ignored
9/12     PLS-00201: identifier 'DBMS_AQ' must be declared
9/12     PL/SQL: Item ignored
14/4     PLS-00320: the declaration of the type of this expression is
      incomplete or malformed

14/4     PL/SQL: Statement ignored
15/4     PLS-00320: the declaration of the type of this expression is
      incomplete or malformed

15/4     PL/SQL: Statement ignored
18/1     PL/SQL: Statement ignored
18/29    PLS-00320: the declaration of the type of this expression is
      incomplete or malformed


How can I resolve it? Thanks in advance. Received on Thu Feb 10 2005 - 09:00:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US