Oracle 12c DBMS_SCHED_FILE_WATCHER

Oracle DBMS_SCHED_FILE_WATCHER_EXPORT Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

Note General Information has been put together based on general interest and the fact that Oracle, while not documenting the package, has granted execute to PUBLIC. If anyone has success deciphering a valid value for version number or other functionality please email me and I will include your demo and credit you as the source. Thank you.

AUTHID CURRENT_USER

Dependencies

DBMS_SCHED_JOB_EXPORT

DBMS_SCHED_MAIN_EXPORT

Documented No

First Available 11.2.0.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

AUDIT_EXP	CREATE_EXP	GRANT_EXP
AUDIT_SYSPRIVS_EXP	DROP_EXP	GRANT_SYSPRIVS_EXP

AUDIT_EXP

Undocumented dbms_sched_file_watcher_export.audit_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

AUDIT_SYSPRIVS_EXP

Undocumented dbms_sched_file_watcher_export.audit_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

-- no version value input changes the return value of this demo so what is required is still not known

set serveroutput on

      

      DECLARE

       bi BINARY_INTEGER;

       rv  VARCHAR2(128);

      BEGIN

        rv := dbms_sched_file_watcher_export.audit_sysprivs_exp('999', bi);

        dbms_output.put_line('Return Value: ' || rv);

        dbms_output.put_line('Out Param: ' || TO_CHAR(bi));

      END;

      /

CREATE_EXP

Undocumented dbms_sched_file_watcher_export.create_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

DROP_EXP

Undocumented dbms_sched_file_watcher_export.drop_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_EXP

Undocumented dbms_sched_file_watcher_export.grant_exp( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_SYSPRIVS_EXP

Undocumented dbms_sched_file_watcher_export.grant_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

-- no version value input changes the return value of this demo so what is required is still not known

      

      set serveroutput on

      

      DECLARE

       bi BINARY_INTEGER;

       rv  VARCHAR2(128);

      BEGIN

        rv := dbms_sched_file_watcher_export.grant_sysprivs_exp('11.2.0.2', bi);

        dbms_output.put_line('Return Value: ' || rv);

        dbms_output.put_line('Out Param: ' || TO_CHAR(bi));

      END;

      /