PACKAGE: SYS.DBMS_STREAMS_HANDLER_ADM

Source

1 PACKAGE dbms_streams_handler_adm AUTHID CURRENT_USER AS
2 
3   -- Create a stmt handler
4   PROCEDURE create_stmt_handler(
5     handler_name       IN VARCHAR2,
6     comment            IN VARCHAR2 DEFAULT NULL);
7 
8   -- Drop a stmt handler
9   PROCEDURE drop_stmt_handler(
10     handler_name       IN VARCHAR2);
11 
12   -- Add a stmt to handler
13   PROCEDURE add_stmt_to_handler(
14     handler_name       IN VARCHAR2,
15     statement          IN CLOB,
16     execution_sequence IN NUMBER DEFAULT NULL);
17 
18   -- Remove a stmt from handler
19   PROCEDURE remove_stmt_from_handler(
20     handler_name       IN VARCHAR2,
21     execution_sequence IN NUMBER DEFAULT NULL);
22 
23 END dbms_streams_handler_adm;