SYS.STOP_ASYNC_EVENT_LISTENER

Stop a running AsyncEventListener configuration. To ensure that no queued events are lost, use SYS.WAIT_FOR_SENDER_QUEUE_FLUSH before stopping the listener.

Syntax

SYS.STOP_ASYNC_EVENT_LISTENER (IN ID VARCHAR(128) NOT NULL)

See also SYS.WAIT_FOR_SENDER_QUEUE_FLUSH.

This procedure stops dispatching events to the callback listener class, and invokes the close() method of the implementation so that the event listener can perform any necessary cleanup.

ID
The unique identifier of the AsyncEventListener configuration that you want to stop.

Example

This procedure stops the event listener configuration, "MyID:"

    java.sql.Connection conn = getConnection();    
    CallableStatement cs = conn.prepareCall("call SYS.STOP_ASYNC_EVENT_LISTENER( ? )");
    cs.setString(1, "MyID");
    cs.execute();