oracle队列java_Oracle高级队列(Advanced Queue)简单实例

Oracle高级队列(Advanced Queue)简单实例

最简单的高级队列的练习，基本上都使用了默认参数。

-- Create Type

create or replace type note as Object(

subject varchar2(100),

Content varchar2(2000),CreateTime date

);

-- Create queue table

begin

sys.dbms_aqadm.create_queue_table(

queue_table => 'NOTETAB',

queue_payload_type => 'TEST.NOTE'

end;

--create queue

begin

sys.dbms_aqadm.create_queue(

queue_name => 'NOTEQ',

queue_table => 'NOTETAB',

queue_type => sys.dbms_aqadm.normal_queue,

max_retries => 5,

retry_delay => 0,

retention_time => 0);

end;

--enqueue

declare

v_Message note;

v_MsgId RAW(16);

v_options DBMS_AQ.ENQUEUE_OPTIONS_T;

v_properties DBMS_AQ.M