I have not used encryption in any of my databases, but have read about obfuscation package etc..
I suggest checking out other alternatives at http://www.cybcon.com/~jkstill/util/, see under
'Oracle Encryption Article and Code'. It may be of help to you.

- Kirti


--- Shivsagar <[Email Address Removed] wrote:
> Hi,
> I need to encrypt and decrypt the column values of a particular table.
> I am aware of DBMS_OBFUSCATION_TOOLKIT.DESENCRYPT and DBMS_OBFUSCATION_TOOLKIT.DESDECRYPT
> procedures.
> Now both of these procedures need a key_string which is like a key to open the lock.
> My problem is, if i write a stored proc to carry out this encryption/decryption, wouldnt the KEY
> be visible to anyone who can view the proc.
> How do i make sure that no one except me and the boss knows the key.
> Sagar
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Oracle LazyDBA home page