Database Security Products (MOSC)

MOSC Banner

Using DBMS_CRYPTO on acolumn with NUMBER datatype

edited Dec 21, 2010 8:01PM in Database Security Products (MOSC) 2 commentsAnswered
Hello All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center