Re: What is value of PL/SQL wrapper?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 18 Oct 2001 06:02:16 -0700
Message-ID: <9qmjso08r7@drn.newsguy.com>

In article <6d90fdaa.0110171908.a14de5b_at_posting.google.com>, jbaumer_at_erols.com says...
>
>When I use the wrap utility of PL/SQL,
>I see the generated hex in the .plb file
>However, I also see the names of all tables and columns used
>in the select I thought I was hiding!
>Am I missing something? Is this just the way it works?
>Is there a better way?
>Many thanks,
>Joel Baumer

it hides your logic, even if it hid the "tables" in some fashion, all_dependencies would give it away.

The link between your procedure and the tables it is dependent on it firmly documented in the data dictionary, they need not even look at the source code.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Thu Oct 18 2001 - 08:02:16 CDT