Hi Friends,

I need yours help in decrypting an encrypted Stored procedure for which i don't have a backup sql file which by mistake i could not able to save to my hard disk.

can u help in retrieving this Stored Procedure again to make the required changes.

Ramkumar A.D.

__________________
Ramkumar A D

There are two ways of encrypting-decypting the pl/sql block in Oracle8i/9i.

--> U can use WRAP utility. But that is one way process. It only encrypts the particular block but once encrypted, it cant be decrypted. It is usually used in the Production Release.

--> U can use DBMS_OBFUSCATION_TOOLKIT package to encrypt/decrypt the particular pl/sql block. It is two way process. But if u want to encrypt an already encrypted file by the same package, it will throw an error. It uses DSA algo and key length is 56 bit. Just chesk the URL to know more about DBMS_OBFUSCATION_TOOLKIT

http://www.oracle-base.com/articles/...Encryption.php

I think it will solve ur problem....


Subhendu De
[email protected]
Software Developer
New Delhi, India