--Включаем PL/Scope со всеми идентификаторами
alter session set plscope_settings='IDENTIFIERS:ALL';
--Компилим исследуемый пакет
SQL код:
alter package ХХХ.ХХХ compile package;
--Проверяем, появились ли записи в идентификаторах
SQL код:
select i.object_name AS package,
i.type,
i.name AS variable_name,
i.object_type
from user_identifiers i
where i.object_type IN ('PACKAGE', 'PACKAGE BODY')
and i.usage = 'DECLARATION'
and i.type in ('VARIABLE', 'CONSTANT')
and i.usage_context_id in
(select i1.usage_id
from user_identifiers i1
where i1.type = 'PACKAGE'
and i1.object_name = i.object_name);