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.


Log in to reply