PL/SQL Unwrapper for SQL Developer v1.0.0

• Released on 2016-06-25
• Show message box with detailed error message when editor content couldn’t be unwrapped
• oddgen plugin implementation changed to show object type node only when wrapped objects exist

PL/SQL Unwrapper for SQL Developer v0.2.0

• Released on 2016-06-18
• Implements the oddgen Java interface to unwrap selected objects to a new worksheet or to the clipboard

PL/SQL Unwrapper for SQL Developer v0.1.1

• Released on 2015-05-17
• Initial GA Release
• Unwraps PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 10g, 11g or 12c
• PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 8i and 9i cannot be unwrapped with this tool
• Extension to Oracle SQL Developer 4
  • Unwraps code in an editor via context menu or keyboard shortcut Ctrl-Shift-U
  • Adds a preferences section
• Oracle SQL Developer Versions 1.x, 2.x, 3.x are not compatible with this extension
• Acknowledgements
  • The unwrap algorithm used in this SQL Developer extension is based on Niels Teusink’s Python script unwrap.py. The character substitution table is taken 1:1 from his source code, which he provided as public domain.
  • The following work helped me to understand the wrapping process:
    • David Litchfield’s The Oracle Hacker’s Handbook: Hacking and Defending Oracle (chapter 5)
    • Pete Finnigan’s How to Unwrap PL/SQL. Pete provides a lot of useful resources on his blog and has shown in this post, that he owns unwrappers for 9i and 10g, which should be capable to handle every wrapped code.
    • Anton Scheffler’s blog post about Unwrapping 10g wrapped PL/SQL
    • Automatic Detection of Vulnerabilities in Wrapped Packages in Oracle by Yaron Gur-Arieh, Nikita Zubrilov and Ilya Kolchinsky
    • Marcel Lambrechts’ blog about Unwrapping Wrapped PL/SQL in Oracle 10gR2 – 12cR1