To: Sohail Jehangir 
Subject: What is a "Wrapper Procedure/Function?"

On Fri, 17 Dec 1999, Sohail Jehangir wrote:

> What it the concept of wrapper pro./fun. Can you explain in detail.
> 
> Regards,
> 
> Sohail Jehangir

Sohail,

Wrappers are used so that you can encrypt or "hide" the source code for
your PL/SQL while you create your package or procedure. This is useful for
companies that do not want to divulge sensitive information, such as
passwords, internal business rules, and intellectual property.

In fact Oracle uses this for much of its internal packages. Just look at
$ORACLE_HOME/rdbms/admin for files with examples of creating wrapped
packages.

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 345+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://www.arikaplan.com                          <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->


Back to Ari Kaplan's Home Page