FRM-40039 - Error cannot attach library when running Designer form

Posted on 2005-08-25
Last Modified: 2007-12-19

I am new to Oracle designer and have go to the point where I am trying to run a form I generated in Oracle Designer but the error I keep having is FRM-40039 cannot attach library - I get this for four libraries that are attached to the form; OFGCALL. OFGTEL, OFGNAVL, OFGMES. I have been playing about and attaching/removing them from the form, and saying NO to the dialog box that comes up saying 'attached library name xxxx contains a non-portable directory specification. Remove path?' seems to mean that the form will then start to have an error on one of the other libraries - so you would think that by attaching them all in this way that the form would run - but it doesnt.

Can someone please help? I have checked the forms path in the registry and it does point to the folder where these pll and plx files are located.

Many thanks
Question by:emmy21
    LVL 6

    Accepted Solution

    See extract from Metalink below which may be useful.

     Applies to:
    Oracle Forms - Version: 9.0.4 to 9.0.4
    Oracle Designer - Version: 9.0.4 to 9.0.4
    Microsoft Windows 2000

    Running a form generated by Designer 9.0.4 the error message
    FRM-40039: cannot attach library %s while opening form %s
    is returned, and the form does not run.
    FORMS90_PATH in the registry is set correctly.
    The form is compiled without any error.
    This occurs also when the form is created by Oracle Forms.
    The problem occurs only when libraries (PLL) are attached with the relative path.

    FORMS90_PATH in default.env installed by iDS10g is not commented as in iDS9i.

    There are two possible solutions:
    1. Comment FORMS90_PATH in default.env if it is not needed.
    2. If FORMS90_PATH in default.env is needed, then add the necessary path to its value,
    like FORMS90_PATH in the registry.

    Author Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    734 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

    21 Experts available now in Live!

    Get 1:1 Help Now