rem $Header: wfjvstop.sql 26.2 2001/11/05 20:09:06 ctilley ship $ rem rem NAME rem wfjvstop.sql - WorkFlow Java Listener Stop Script rem USAGE rem @wfjvstop rem DESCRIPTION rem Places message on wf_outbound_queue which when processed by Java Listener rem will cause the Java Listener to stop. rem rem dbdrv: none prompt Placing Message on Outbound Queue..... declare lMessageHandle raw(16); begin WF_Queue.enqueue_event( queuename =>wf_queue.OutboundQueue, itemtype => NULL, itemkey => NULL, actid => NULL, correlation => 'EXTJAVA', delay => 0, funcname => 'JAVASTOP', paramlist => NULL, result => NULL, message_handle => lMessageHandle, priority => -1); end; / commit; exit;