1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

API's ( How do I identify the package name and version of the API)

Discussion in 'Oracle Apps Technical' started by shrikantgarud, Oct 12, 2009.

  1. shrikantgarud

    shrikantgarud Forum Advisor

    Likes Received:
    Trophy Points:
    To identify the package name of an API compiled in the Oracle database, enter the following select statement as the User APPS in SQL*Plus
    Code (SQL):

    >SELECT text
    FROM all_source
    WHERE name LIKE '%your_api_name%'
    --(example: '%HR_POSITION_API%')
    AND text LIKE '%Header%';
    This will return the header line of the package and package body showing the package name and current version number.

    To compare the API package versions in your operating system directory and compiled in your database, execute a command from the API directory, similar to the following Unix command:

    Code (Text):
    prompt>strings -a packagename | grep Header
    This returns all occurrences of the package, package body and the file version number. Version numbers should match what is compiled in the database.