wich package are wrapped

[steeve123]

Is there a way to know what package in my database are wrapped.

like a select in the data dictionnairy tables.

[jmodic]

When a package body is wrapped, its first line in the DBA_SOURCE is: "package body PACKAGE_NAME wrapped". So you can use the following query to count all your wrapped packages:

SELECT COUNT(*) FROM dba_source
WHERE type = 'PACKAGE BODY'
AND line = 1
AND INSTR(text, 'wrapped') > 0;