Prev: Upgrade issue? Can't start/stop oracle if non dba started it
Next: *NEWBIE* Help needed for decoding that ...
From: jyu on 10 Feb 2005 10:00
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.

 | 
Pages: 1
Prev: Upgrade issue? Can't start/stop oracle if non dba started it
Next: *NEWBIE* Help needed for decoding that ...