Releases · Trivadis/plsql-unwrapper-sqldev

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

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

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

Provide feedback