select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';




select * from all_object a where a.object_type='procedure' and a.object_name like '%XXX%';