Hi. I am working on an application where we need to encrypt information before it is sent to the database. I know that the database has a great set of stored procedures for handling encryption and decryption. The only challenge here is the fact that I would need to send unencrypted information to the database "in the clear". Ideally, I'd like to encrypt the information inside the form and then send it to the database. On retrieval, retrieve the information and then have the forms application decrypt the encrypted information.
Has anyone done this as a package inside of a PLL without any calls to a DBMS_ package?
Thanks,
BradW