Encryption and Decryption compatibility in C# and PL/SQL
is there any 开发者_运维百科kind of Encryption and Decryption functions that are in c# and Oracle PL/SQL? I mean I can encrypt a string in one and decrypt it in the other? any help, I'm not good in security algorithm!
cheers
In Oracle, you can use the dbms_obfuscation_toolkit. If you want to encrypt and decrypt, you might try DES encryption. For Oracle, its dbms_obfuscation_toolkit.DESEncrypt, and for C# its DESCryptoServiceProvider (in System.Security.Cryptography). You'll also need to use the same key of course if encrypting/decrypting between the two.
Also, DBMS_CRYPTO is intended to replace DBMS_OBFUSCATION_TOOLKIT I believe, and should have various encryption algorithms for Oracle.
精彩评论