Oracle SQL: "Decrypt" PL SQL Packages

 Requirement

You've spotted some PL/SQL code that looks encrypted.

The code is in an installation script or you have retrieved it using dbms_metadata.get_ddl.


Solution

This isn't encrypted, merely masked using a technique called wrapping.  This is done to prevent anyone from displaying that text with the static data dictionary views. 

You can use tools like Unwrap It!.

Paste the entire code, including the create/replace statement into the box.



Result


I've masked the result obviously.


Acknowledgement





Comments