Query to Checking Version of Database Package

The relevant query is as follows:

SELECT text

FROM     dba_source

WHERE  name = ‘<PACKAGE_NAME >’

AND        text LIKE ‘%Header:%’;

For example, look for the 2 files that make up the package “PO_INQ_SV’:

TEXT

----------------------------------------------------------------------------------------------------------

/*   $Header:  POXPOVPS.pls   80.1.7016.2  98/02/24   20:00:59  porting ship $   */

/*   $Header:  POXPOVPB.pls   80.3.7016.4  98/07/01   16:47:41  porting ship $   */

Notice the results give us the file names that make up the Header/Spec and Body of the package. The B and the S at the end of the 7 letters indicate the Body and Spec file.