Oracle | MGWI

Oracle MGWI_CRYPTO 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

Purpose Messaging Gateway Cryptography Utilities. Based on subprogram names this package is likely deprecated.

Note that this package does not have dependencies on DBMS_OBFUSCATION_TOOLKIT and DBMS_OBFUSCATION_TOOLKIT_FFI but some of the demos below generate exceptions because these objects have been desupported since database version 21c.

AUTHID DEFINER

Dependencies

DBMS_CRYPTO	MGW$_GATEWAY	UTL_I18N
DBMS_MGWADM	MGWI_ADMIN	UTL_RAW
DBMS_SYS_ERROR	MGWI_MSGLINK

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the MGW_AGENT_ROLE role.

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

SQL> @?/mgw/admin/mgwicry.plb

      

      SP2-0808: Package created with compilation warnings

      

      Grant succeeded.

      

      SQL> sho err

      Errors for PACKAGE MGWI_CRYPTO:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      1/1 PLW-05018: unit MGWI_CRYPTO omitted optional AUTHID clause;

      default value DEFINER used

      

      12/37 PLW-06010: keyword "KEY" used as a defined name

      18/37 PLW-06010: keyword "KEY" used as a defined name

      27/5 PLW-06010: keyword "KEY" used as a defined name

      36/5 PLW-06010: keyword "KEY" used as a defined name

      

      SQL> @?/mgw/admin/mgwicryb.plb

      

      SP2-0810: Package Body created with compilation warnings

      

      SQL> sho err

      Errors for PACKAGE BODY MGWI_CRYPTO:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      105/37 PLW-06010: keyword "KEY" used as a defined name

      135/37 PLW-06010: keyword "KEY" used as a defined name

      219/5 PLW-06010: keyword "KEY" used as a defined name

      278/5 PLW-06010: keyword "KEY" used as a defined name

Subprograms

DECRYPT_10G	ENCRYPT_10G	ENCRYPT_STR_11G
DECRYPT_11G	ENCRYPT_11G	MIGENC_10G_TO_11G
DECRYPT_STR_10G	ENCRYPT_STR_10G	MIGENC_11G_TO_10G
DECRYPT_STR_11G

DECRYPT_10G

Undocumented mgwi_crypto.decrypt_10g( src IN VARCHAR2, key IN VARCHAR2) RETURN VARCHAR2;

TBD

DECRYPT_11G

Undocumented mgwi_crypto.decrypt_11g( src IN RAW, key IN RAW) RETURN RAW;

TBD

DECRYPT_STR_10G

Undocumented mgwi_crypto.decrypt_str_10g(src IN VARCHAR2) RETURN VARCHAR2;

SELECT mgwi_crypto.decrypt_str_10g('Pass123');

             *

      ORA-28232: invalid input length for obfuscation toolkit

DECRYPT_STR_11G

Undocumented mgwi_crypto.decrypt_str_11g(src IN RAW) RETURN VARCHAR2;

SELECT mgwi_crypto.decrypt_str_11g(utl_raw.cast_to_raw('Password123'));

             *

      ORA-28817: PL/SQL function returned an error.

ENCRYPT_10G

Undocumented mgwi_crypto.encrypt_10g( src IN VARCHAR2, key IN VARCHAR2) RETURN VARCHAR2;

TBD

ENCRYPT_11G

Undocumented mgwi_crypto.encrypt_11g( src IN RAW, key IN RAW) RETURN RAW;

TBD

ENCRYPT_STR_10G

Undocumented mgwi_crypto.encrypt_str_10g(src IN VARCHAR2) RETURN VARCHAR2;

SELECT mgwi_crypto.encrypt_str_10g('N0wAy1n0r0u$');

             *

      ORA-29275: partial multibyte character

      

      SELECT mgwi_crypto.encrypt_str_10g('N0wAy1n0r0ut');

      

      MGWI_CRYPTO.ENCRYPT_STR_10G('N0WAY1N0R0UT')

      --------------------------------------------

      ┐6n┐1d┐┐┐┐↑U^1

ENCRYPT_STR_11G

Undocumented mgwi_crypto.encrypt_str_11g(src IN VARCHAR2) RETURN RAW;

SELECT mgwi_crypto.encrypt_str_11g('N0wAy1n0r0u$');

      

      MGWI_CRYPTO.ENCRYPT_STR_11G('N0WAY1N0R0U$')

      --------------------------------------------

      777F1B89C492A55FC4C0C9B6FA146BA9

MIGENC_10G_TO_11G

Undocumented mgwi_crypto.migenc_10g_to_11g(encdata IN VARCHAR2) RETURN RAW;

SELECT mgwi_crypto.migenc_10g_to_11g('Pass123');

             *

      ORA-28232: invalid input length for obfuscation toolkit

MIGENC_110G_TO_10G

Undocumented mgwi_crypto.migenc_11g_to_10g(encdata IN RAW) RETURN VARCHAR2;

SELECT mgwi_crypto.migenc_11g_to_10g('777F1B89C492A55FC4C0C9B6FA146BA9');

             *

      ORA-29275: partial multibyte character

      

      SELECT mgwi_crypto.migenc_11g_to_10g(utl_raw.cast_to_raw('Password123'));

             *

      ORA-28817: PL/SQL function returned an error.