jyu
2005-02-10 15:00:05 UTC
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.
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.