SYS.REMOVE_LISTENER

Remove a listener implementation that you previously added to a table.

Syntax

SYS.REMOVE_LISTENER
(
IN ID VARCHAR(128),
IN SCHEMA VARCHAR(128),
IN TABLE VARCHAR(128)
)
ID
The unique identifier of the listener that you want to remove.
SCHEMA
The schema of the table that has the specified listener.
TABLE
The name of the table that has the specified listener.

Example

Connection conn = getConnection();
CallableStatement cs = conn
  .prepareCall("CALL SYS.REMOVE_LISTENER(?,?,?)");
cs.setString(1, "id");
cs.setString(2, "test");
cs.setString(3, "table");
cs.execute();