oracle12c java 队列_Oracle高级队列 - ORA-38818 - 对已编辑对象的非法引用

...

GRANT EXECUTE ON dbms_aq TO sch_utl

/

GRANT EXECUTE ON dbms_aqadm TO sch_utl

/

GRANT aq_administrator_role TO sch_utl

/

BEGIN

DBMS_AQADM.GRANT_SYSTEM_PRIVILEGE(privilege => 'MANAGE_ANY'

,grantee => 'sch_utl'

,admin_option => FALSE);

END;

/

1.

create or replace type o_utl_q_log as object

(/*some variables*/

constructor function o_utl_q_log return self as result,

member procedure queue_enqueue,

static function queue_dequeue(p_wait number default 0)

return o_utl_q_log,

);

2.

create or replace type body o_utl_q_log

(

...

);

类型和其的身体没有错误编译，当发生的问题;

3.

begin

dbms_aqadm.create_queue_table(queue_table => 't_utl_q_log'

, queue_payload_type => 'o_utl_q_log'

, sort_list => 'PRIORITY,ENQ_TIME'

, storage_clause => 'tablespace TS_UTL_Q_TABLE_LOG'

, comment => 'Log queue table') ;

end;

我得到这个犯错的说明;

ORA-38818：非法参照editioned对象SCH_UTL.O_UTL_Q_LOG

ORA-06512：在 “SYS.DBMS_AQADM”，线81

ORA-06512：在第2行

38818. 00000 - “非法参照editioned对象％s。％s“

*原因：试图违反规则”未编制对象

可能不依赖于已编辑的对象。“

为了以防万一，我正在使用XE 11g R2。

非常感谢任何人的帮助！

2016-10-10

RafalK