Wrapping PL/SQL Code

[Kari]

Hi,

we have closer to 100 PL/SQL packages. Is there a way how to wrap these in one go?

tia,
Kari

ps. The Oracle version is 10gR2

 

[Marco Kalter]

You can do this in 3 steps:

1. Use the Export User Objects tool to export the packages to source files (1 file per object).

2. Generate a script that performs the wrapping. For example:

set feedback off
set heading off
spool w:\exports\wrapall.cmd
select 'wrap iname=' || o.object_name || '.bdy'
from user_objects o
where o.object_type = 'PACKAGE BODY'
order by o.object_name;
spool off
set feedback on
set heading on

You can run this script from the Command Window.

3. Run the generated wrapall.cmd script from the Windows command line.

 

[Kari]

Thanks,

already this helps a lot.

Still, having this kind of "bulk" wrapping feature included in PL/SQL Developer would nice.

Kari