A serious "I-Hate"
-
WRAP...Fantastic little util to obfuscate the source of a package...fan-frickin-tastic.
But the kicker.
Oracle 9i supports ANSI join syntax (select a.name, b.dept, b.desc from emp a left outer join dept b on (a.dept=b.dept) ... blah blah blah)...
BUT wrap was not updated to recognize such ANSI goodness
serious PITA
-
You can use the
edebug=wrap_new_sql
option; be beware, this causes all SQL statements to appear in plaintext in the wrapped file.
-
Which, of course, would negate the major reason for wrapping code in the first place...
-
[quote user="rewind"]Which, of course, would negate the major reason for wrapping code in the first place...
[/quote]Well, the PL/SQL algorithms are still wrapped; and the SQL statements being executed during runtime are visible to a DBA anyway.