How to get API Package Code via SQL

Post date: Aug 06, 2013 6:30:38 AM

The following will get API Package Body details:

SELECT text

FROM dba_source

WHERE TYPE = 'PACKAGE BODY'

AND upper(NAME) LIKE :PackageName

ORDER BY line;

Set the type to 'PACKAGE BODY' to see all the code associated with the API or set it to 'PACKAGE' to simply get the header information of the API.