Oracle | DBMS_XS

Oracle DBMS_XS_SYSTEM_FFI Version 21c

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 Real Application Security

AUTHID CURRENT_USER

Dependencies

DBMS_XSP_LIB

DBMS_XS_SYSTEM

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbmskzxp.sql

Subprograms

BLOCK_PRINCIPAL_CHANGES	CHECK_XSPROVISION	SET_XS_ACL_RESULT_SIZE
CHECK_XSCALLBACK

BLOCK_PRINCIPAL_CHANGES

Undocumented dbms_xs_system_ffi.block_principal_changes(bpc IN BOOLEAN);

exec dbms_xs_system_ffi.block_principal_changes(FALSE);

      BEGIN dbms_xs_system_ffi.block_principal_changes(FALSE); END;

      *

      ERROR at line 1:

      ORA-06521: PL/SQL: Error mapping function

      ORA-06512: at "SYS.DBMS_XS_SYSTEM_FFI", line 3

      ORA-06512: at line 1

CHECK_XSCALLBACK

Undocumented dbms_xs_system_ffi.check_xsCallback(granted OUT BOOLEAN);

DECLARE

       b BOOLEAN;

      BEGIN

        dbms_xs_system_ffi.check_xsCallback(b);

        IF b THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

      TRUE

CHECK_XSPROVISION

Undocumented dbms_xs_system_ffi.check_xsProvision(granted OUT BOOLEAN);

DECLARE

       b BOOLEAN;

      BEGIN

        dbms_xs_system_ffi.check_xsProvision(b);

        IF b THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

      TRUE

SET_XS_ACL_RESULT_SIZE

Undocumented dbms_xs_system_ffi.set_xs_acl_result_size(numacl IN PLS_INTEGER);

exec dbms_xs_system_ffi.set_xs_acl_result_size(3);