| 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. |
| Note: This page |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthest.plb |
| Dependencies |
| DBMS_SCHED_JOB_EXPORT |
| DBMS_SCHED_MAIN_EXPORT |
|
| Security Model |
Owned by SYS with execute granted to PUBLIC |
| Subprograms |
|
| |
| 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;
/ |
