Unable to compile a package in Oracle Forms 4.5

Posted on 2009-04-22
Last Modified: 2013-11-16
I have a forms 4.5 form that uses external database packages.
I access the package typically:

txt := pkg_test.aa(:b1.txt_in) ;
where pkg_test is the package name aa is the function.

This all works fine against database 8.1.7 and
database 10g Express Edition Release

However when I try and run this against a different database
10g Enterprise Edition Release
I am unable to compile anything that uses an external package !

Yes I know its an old version of forms and it not supported by Oracle,
but this is what happens in industry !

Question by:geoffbates
    LVL 20

    Expert Comment

    What happens ?
    Do you get error messages ?

    Author Comment

    I get error 303 at line xx column xx
    qualifier pkg_test.aa must be declared.

    This package exists in the database. I can  use it at plsql prompt OK and it works fine.
    When I compile against Db it works fine.  When I compile against Db
    I get the error message.

    A public synonym exists and execute grant to public exists.

    LVL 20

    Accepted Solution

    Check if you are connected to the same database in forms as in sqlplus.
    1. create an new function (or any other object) in the database via sqlplus.
    2. in forms builder connect to the database
    3. check the object navigator in the forms builder
        look for the existence of the new function in the 'database objects'     (last brace beneath 'object libraries' and 'builld in packages'.

    If you find the new function try to use it in the form : if you get the same error then I am stuck.
    If you don't find the new function your probably connected to another database :
    my guess is there is a different tnsnames.ora  used by sqlplus and forms builder. (same servicename but different connection)

    Good luck.

    Author Comment

    In the object navigator  I can see the function OK. If I double click on it the actual code on the database is displayed.  So forms can see the function !! It just will not compile
    LVL 20

    Expert Comment

    Doesn't any function call compile or only some calls (= pkg_test.aa)

    Author Comment

    cant get any database procedures/functions/packages to compile against this version of oracle

    Like I said I can see the objects..

    Works for it  but not on

    LVL 5

    Expert Comment

    Were you able to resolve this compilation issue eventually?
    We are getting the same problem.

    Forms [32 Bit] Version (Production)
    Oracle Database 10g Enterprise Edition Release - 64bit Production
         With the Partitioning, Data Mining and Real Application Testing options
    Oracle Toolkit Version (Production)
    PL/SQL Version (Production)
    Oracle Procedure Builder V1. - Production
    Oracle Virtual Graphics System Version (Production)
    Oracle Tools GUI Utilities Version (Production)

    Expert Comment

    Was this ever resolved. I have same issue

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
    Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now