Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: obfuscate an integer and store in a number column
Pedro Lopes wrote:
> Hi all,
> I have to encrypt some numeric data (the column is a number(22)).
> After looking at dbms_obfuscation_toolkit (database is 9.2.0.5) I
> realised that the output will be
> alfanumeric (hex) and that I couldn't fit the encrypted value in the
> number column.
>
> Does anyone have an idea on how can I achieve this ?
>
> I tried with some conversions like....
> convert the number to hexadecimal,
> hexadecimal to RAW,
> encrypt,
> convert RAW to hexadecimal,
> convert Hex to number
>
> but I ended with a 38 digit number...that doesn't fit on the column.
>
> I cannot change the type of the column to varchar since this is an
> oracle ebusiness suite application.
>
> thanks,
> Pedro
What is the actual security requirement?
One possibility:
Change the data type.
Store the encrypted version in the column
Store the number in a function based index?
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Feb 09 2005 - 21:29:50 CST