0 Replies Latest reply on Jan 24, 2014 4:39 PM by Craig Bagley

    How can I call a decrypt function using custom sql?

    Craig Bagley

      I've got an application that stores encrypted data, and I'm trying to wrap the selected parameters in a decrypt function in the custom SQL box.  Instead of something like:

       

      select first_name from people

       

      I need to be able to execute:

      select data_encrypt.decrypt(first_name) from people

       

      Unfortunately, when I execute the above I get:

      Capture.JPG.jpg

       

      I'm handling the actual act of decrypting at the database user level, so the only real thing I need to do inside the custom SQL is call the decrypt function.

       

      I'm currently using a demo version of 8.0 desktop in the hopes that I can get this to work somehow and buy a full license. Does anyone have any experience working with something like this?

       

      Thanks for any help!