Oracle | DBMS_STREAMS_CONTROL

Oracle DBMS_STREAMS_CONTROL_ADM Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented part of Streams administration

Streams was deprecated 03-Jan-2018 but this package still exists in 23c.

AUTHID DEFINER

Dependencies

DBMS_AQADM_SYSCALLS

DBMS_XDBZ

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to XDB

Source {ORACLE_HOME}/rdbms/admin/prvthstr.plb

Subprograms

Undocumented dbms_streams_control_adm.is_skip_capture RETURN BOOLEAN;

BEGIN

        IF dbms_streams_control_adm.is_skip_capture THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

RESUME_CAPTURE

Undocumented dbms_streams_control_adm.resume_capture;

exec dbms_streams_control_adm.resume_capture;

      

      PL/SQL procedure successfully completed.

SKIP_CAPTURE

Undocumented dbms_streams_control_adm.skip_capture;

exec dbms_streams_control_adm.skip_capture;

      

      PL/SQL procedure successfully completed.