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

"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

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;

      /