oracle application 11i


    How do I identify the package name and version of the API?

    Share
    avatar
    shrikantgarud
    Admin

    Posts : 109
    Join date : 2007-12-02
    Age : 31
    Location : Clover Infotech

    How do I identify the package name and version of the API?

    Post  shrikantgarud on Mon Dec 03, 2007 8:04 am

    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
    >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:
    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.

      Current date/time is Tue Dec 12, 2017 3:18 am