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 -> Error PLS-00302 in package DBMS_AQADM

Error PLS-00302 in package DBMS_AQADM

From: Mario Röcher <mario_at_addfactory.com>
Date: 23 Oct 2001 14:11:06 -0700
Message-ID: <375e6418.0110231311.4d6deb72@posting.google.com>


Hi,
i have following problem:
The following error has occurred:
PACKAGE SYS.DBMS_AQADM
On line: 152
PLS-00302: Komponente 'AQ$_QUEUES' muß deklariert werden

This is the code from the procedure:
PROCEDURE create_q_dictionary(

		    q_schema        IN  VARCHAR2,
                    q_name          IN  VARCHAR2,
                    qt_name         IN  VARCHAR2,
                    oid             IN  system.aq$_queues.oid%TYPE,
	            table_objno     IN  system.aq$_queue_tables.objno%TYPE, 
                    q_type          IN  INTEGER,
...

The oracle version is 8.0.5.0.0.
system.aq$_queues.oid exists.
I don´t know where the problem is.
could anybody help me please ? Received on Tue Oct 23 2001 - 16:11:06 CDT

Original text of this message

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