Using DBMS_CRYPTO on acolumn with NUMBER datatype
I am using DBMS_CRYPTO to encrypt and decrypt data in a table. Two functions encrypt_data and decrypt_data have been created. Both the functions seem to be working fine for columns with VARCHAR2 datatypes, but donot seem to be working for if the column has NUMBER datatype. What is the reason??
I have the following functions created:
1. Encrypt_data_varchar - This is for columns with varchar datatypes, works fine.
2. Decrypt_data_varchar - This is for columns with varchar datatypes, works fine.
3. Encrypt_data_number - This is for columns with NUMBER datatypes
4 Decrypt_data_number - This is for columns with NUMBER datatypes