Home » SQL & PL/SQL » SQL & PL/SQL » rc4 encryption in 9i (Oracle 9i)
rc4 encryption in 9i [message #340832] Thu, 14 August 2008 09:26 Go to next message
hasi1217
Messages: 3
Registered: August 2008
Junior Member
Hi

I need to decrypt a string in oracle 9i using rc4 standard. This string is encrypted by a third party using rc4 standard. Is it possible to decrypt this string using dbms_crypto_toolkit? If yes, could anybody explain how. Any help/suggestions will be appreciated.

thank you.
Re: rc4 encryption in 9i [message #340852 is a reply to message #340832] Thu, 14 August 2008 11:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The only encryption algorithms provided with your version are those enumerated in documentation:
Oracle9i Supplied PL/SQL Packages and Types Reference

If you want more, you have to, for instance, create or find a Java class and embed it in Oracle.

Regards
Michel
Re: rc4 encryption in 9i [message #340857 is a reply to message #340852] Thu, 14 August 2008 11:57 Go to previous messageGo to next message
hasi1217
Messages: 3
Registered: August 2008
Junior Member
hi Michel,
thanks a lot for responding. Was wondering if I should consider dbms_crypto_toolkit at all. I do see some functions for encrypting and decrypting a string. I don't understand some of the parameters passed in there (like Persona etc). I couldn't find much documentation on this package either. I'm sure its possible on 10g (using dbms_crypto pkg). I've limited knowledge on Java but I'm still exploring this option.

thanks again,
Hasitha.
Re: rc4 encryption in 9i [message #340859 is a reply to message #340857] Thu, 14 August 2008 12:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I can't answer you as dbms_crypto_toolkit is not an Oracle package and so don't know it.
dbms_crypto is for 10g and up only.
In 9i, there is dbms_obfuscation_toolkit but it supports only DES and DES3 agorithms.

There are many Java classes available on Internet including all encryption algorithms.

Regards
Michel

[Updated on: Thu, 14 August 2008 12:14]

Report message to a moderator

Re: rc4 encryption in 9i [message #340861 is a reply to message #340859] Thu, 14 August 2008 12:29 Go to previous message
hasi1217
Messages: 3
Registered: August 2008
Junior Member
Yea you are right, its not a package. Its an interface provided by Oracle security server. Anyway thanks for your prompt replies. Appreciate your time.

regards,
Hasitha
Previous Topic: Create Table As Select
Next Topic: Create table can not be executed in procedure?
Goto Forum:
  


Current Time: Fri Dec 09 02:23:25 CST 2016

Total time taken to generate the page: 0.09619 seconds