bz_prp_enqueue_eg.sql

oracle9i+j2ee开发aq oracle9i+j2ee开发aq oracle9i+j2ee开发aq

REM script name: bz_enqueue_eg.sql
REM Shows various ways to do an enqueue
REM
REM version: 9i

REM====================================================================
REM I. Enqueue with a recipient list
REM====================================================================

declare
	enqopt	dbms_aq.enqueue_options_t;
	mprop	dbms_aq.message_properties_t;
	enq_msgid	RAW(16);
begin
	dbms_aq.enqueue(
		queue_name => 'bzcardorders_q',
		enqueue_options => enqopt,
		message_properties => mprop,
		payload => bzcardorder_typ(101, 'Brajesh', 'Goyal','RUSH'),
		msgid => enq_msgid);
	commit;
end;
/