Oracle DBMS_STREAMS_HANDLER_ADM
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_APPLY_ADM DBMS_LOGREP_UTIL DBMS_STREAMS_HANDLER_INTERNAL
DBMS_APPLY_ADM_INTERNAL DBMS_STANDARD DBMS_UTILITY
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsstr.sql
Subprograms
 
ADD_STMT_TO_HANDLER
Add a statement to an existing handler dbms_streams_handler_adm.add_stmt_to_handler(
handler_name       IN VARCHAR2,
statement          IN CLOB,
execution_sequence IN NUMBER DEFAULT NULL);
See CREATE_STMT_HANDLER Demo Below
 
CREATE_STMT_HANDLER
Create a statement handler dbms_streams_handler_adm.create_stmt_handler(
handler_name IN VARCHAR2,
comment      IN VARCHAR2 DEFAULT NULL);
exec dbms_streams_handler_adm.create_stmt_handler('UWTest', 'Statement Handler Creation Test');

desc dba_streams_stmt_handlers

col handler_name format a20
col handler_comment format a32
col creation_time format a30
col modification_time format a20

SELECT *
FROM dba_streams_stmt_handlers;

DECLARE
 c CLOB := 'SELECT COUNT(*) FROM dual';
BEGIN
  dbms_streams_handler_adm.add_stmt_to_handler('UWTest', c, 1);
END;
/

desc dba_streams_stmnt

col statement format a30

SELECT *
FROM dba_streams_stmts;

exec dbms_streams_handler_adm.remove_stmt_from_handler('UWTest', 1);

SELECT *
FROM dba_streams_stmts;

exec dbms_streams_handler_adm.drop_stmt_handler('UWTest');

SELECT *
FROM dba_streams_stmt_handlers;
 
DROP_STMT_HANDLER
Drop a statement handler dbms_streams_handler_adm.drop_stmt_handler(handler_name IN VARCHAR2);
See CREATE_STMT_HANDLER Demo Above
 
REMOVE_STMT_FROM_HANDLER
Remove a statement from a handler dbms_streams_handler_adm.remove_stmt_from_handler(
handler_name       IN VARCHAR2,
execution_sequence IN NUMBER DEFAULT NULL);
See CREATE_STMT_HANDLER Demo Above

Related Topics
Built-in Functions
Built-in Packages
DBMS_CDC_PUBLISH
DBMS_CDC_SUBSCRIBE
DBMS_CDC_UTILITY
DBMS_STREAMS
DBMS_STREAMS_ADM
DBMS_STREAMS_ADM_UTL_INT
DBMS_STREAMS_ADVISOR_ADM
DBMS_STREAMS_AUTH
DBMS_STREAMS_CDC_ADM
DBMS_STREAMS_CONTROL_ADM
DBMS_STREAMS_HANDLER_INTERNAL
DBMS_STREAMS_MC
DBMS_STREAMS_MC_INV
DBMS_STREAMS_MESSAGING
DBMS_STREAMS_PUB_RPC
DBMS_STREAMS_RPC_INTERNAL
DBMS_STREAMS_TABLESPACE_ADM
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved