Oracle | DBMS_SCHED_FILE_WATCHER

Oracle DBMS_SCHED_FILE_WATCHER_EXPORT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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

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;

      /

      Return Value:

      Out Param: 0

      

      PL/SQL procedure successfully completed.

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('19.3.0.0', bi);

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

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

      END;

      /

      Return Value:

      Out Param: 0

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: