enq.sql

来自「oracle9i+j2ee开发aq oracle9i+j2ee开发aq or」· SQL 代码 · 共 19 行

connect bz_adm/bz_adm

declare
 enq_opt  dbms_Aq.enqueue_options_t;
 msg_prp  dbms_aq.message_properties_t;
 payload   bzcardorder_typ;
 msgid    raw(16);

begin

 payload := bzcardorder_typ(23, 'a', 'b', 'c');
 dbms_aq.enqueue('BZCARDORDERS_Q', enq_opt, msg_prp, payload, msgid);

 commit;

end;
/