Oracle 12c DBMS_XS

Oracle DBMS_XS_SYSTEM Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

Purpose Real Application Security

AUTHID CURRENT_USER

Dependencies

DBMS_XS_SYSTEM_FFI

Documented No

First Available 12cR1

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.block_principal_changes (bpc IN BOOLEAN);

exec dbms_xs_system.block_principal_changes(FALSE);

      BEGIN dbms_xs_system.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 "SYS.DBMS_XS_SYSTEM", line 5

      ORA-06512: at line 1

CHECK_XSCALLBACK

Undocumented dbms_xs_system.check_xsCallback RETURN BOOLEAN;

BEGIN

        IF dbms_xs_system.check_xsCallback THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

CHECK_XSPROVISION

Undocumented dbms_xs_system.check_xsProvision RETURN BOOLEAN;

BEGIN

        IF dbms_xs_system.check_xsProvision THEN

          dbms_output.put_line('TRUE');

        ELSE

          dbms_output.put_line('FALSE');

        END IF;

      END;

      /

SET_XS_ACL_RESULT_SIZE

Undocumented dbms_xs_system.set_xs_acl_result_size (numacl IN PLS_INTEGER);

exec dbms_xs_system.set_xs_acl_result_size(3);