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 is now availble. If you haven't you downloaded already: Why?

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.