Oracle | DBMS_SCHED_EXPORT

Oracle DBMS_SCHED_EXPORT_CALLOUTS 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 Scheduler Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_SCHED_JOB_EXPORT

DBMS_SCHED_MAIN_EXPORT

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

SCHEMA_CALLOUT

SCHEMA_INFO_EXP

SCHEMA_CALLOUT

Undocumented dbms_sched_export_callouts.schema_callout( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2);

exec dbms_sched_export_callouts.schema_callout('C##APPLIC', 0, 1, '23.2');

      

      PL/SQL procedure successfully completed.

SCHEMA_INFO_EXP

Undocumented dbms_sched_export_callouts.schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal VARCHAR2(60);

       nblk BINARY_INTEGER;

      BEGIN

        retVal := dbms_sched_export_callouts.schema_info_exp('C##APPLIC', 0, 1, '23.2', nblk);

        dbms_output.put_line('retVal: ' || retVal);

        dbms_output.put_line('New Block: ' || TO_CHAR(nblk));

      END;

      /

      retVal:

      'New Block: 0

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx