Re: compiled version of pl/sql packages

Oracle supplt WRAPPED packages, which are encyrpted source code, so that the intelectual copyright is protected. Once a package is WRAPPED, there is no UNWRAP command, so make sure you keep the origional source code. You can use the WRAP command or WRAP23 on NT from Oracle7 v7.3 onwards.

This is still only source code, there are a number of data dictionary tables, IDL_UB2$, IDL_??? that store the compiled code of a PL/SQL package which is created when you run the 'create package' command. A package remains compiled until a dependancy is modified, aka Another package or a table or an Index, and then Oracle will automatically recompile the package for you when it is next called.

Hope this helps,
Andrew

Olivier STEINBERG wrote:

> Hi, does anybody knows how to compile PL/SQL packages in oracle DB in order
> to leave them in the catalog as binaries only.
>
> For instance ORACLE own packages bodies are stored in binary in the the DB.
> (e.g Dbmsutil.sql)
> Is there any tool available to the public or is it only for ORACLE internal
> use ?
>
> Thank's for reply.
>
> Olivier STEINBERG (Paris)
Received on Mon Jun 07 1999 - 00:26:37 CDT