[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Unable to compile a package in Oracle Forms 4.5

Posted on 2009-04-22
Medium Priority
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 21

Expert Comment

ID: 24207709
What happens ?
Do you get error messages ?

Author Comment

ID: 24208382
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 21

Accepted Solution

flow01 earned 1500 total points
ID: 24210132
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.
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.


Author Comment

ID: 24212403
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 21

Expert Comment

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

Author Comment

ID: 24213509
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


Expert Comment

ID: 26078082
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

ID: 38646230
Was this ever resolved. I have same issue

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Loops Section Overview

872 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