proc_fun_in_package

Published February 22, 2026 By Sai Sree Ram Gundepudi
select OBJECT_TYPE,OBJECT_NAME,NAME, TYPE from user_identifiers
where  object_type like 'PACKAGE%'
and    usage in ('DECLARATION', 'DEFINITION')
and    type in ('FUNCTION', 'PROCEDURE')
and OBJECT_NAME like 'AASC_CUSTOM_FUNCTIONS_PKG'
order by 1,2,4,3 ;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article