Search for wrapped packages/procedures in Oracle SQL

Question

A simple question but a google and SO search hasn't turned anything up.

Does anyone know if it is possible to search in the Oracle Data Dictionary to find all wrapped (that have been obfuscated using the 'wrap' utility) packages/procedures?

Thanks, John.

Answer 1

You have to check the first line of the source code:

select type, owner, name
from all_source
where line = 1
  and instr(text, 'wrapped') > 1;

Except for very long wrapped packages, wrapped types usually have the whole code in one row (line 1) while unwrapped types have a separate row for each line of source code.