SYS.START_ASYNC_EVENT_LISTENER

Start an installed AsyncEventListener configuration.

Syntax

SYS.START_ASYNC_EVENT_LISTENER ( 
IN ID VARCHAR(128) NOT NULL 
) 
		
ID
The unique identifier of the AsyncEventListener configuration that you want to start.

Example

After executing this procedure, SQLFire assigns a thread to service the queue of the "MyID" event listener, dispatching events to the callback class:

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