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
v0.2.0
4 years ago
Released on 2016-06-18
Implements the oddgen Java interface to unwrap selected objects to a new worksheet or to the clipboard
v0.1.1
4 years ago
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:
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.