2 Replies Latest reply on Aug 3, 2015 1:52 AM by Adam Wickes

    Using  EVALUATE and DBMS_OBFUSCATION_TOOLKIT.md5

    Adam Wickes

      Hi all,

       

      Looking to encrypt some data on the fly within analysis or subject area.

      I know that I can use the following code within the database.... Just wondering what syntax I need to use within the EVALUATE function.

       

      SELECT DBMS_OBFUSCATION_TOOLKIT.md5 (input => UTL_RAW.cast_to_raw('a|b|123456')) from DUAL;

       

      My current code looks like this:

       

      EVALUATE('DBMS_OBFUSCATION_TOOLKIT.md5(%1)' AS CHAR , 'input => UTL_RAW.cast_to_raw(''a|b|123456'')')

       

      Unfortunately, it returns:

       

      [nQSError: 42015] Cannot function ship the following expression

       

       

      Appreciate the help

      Adam