Solved

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

Posted on 2005-08-25
6,077 Views
Last Modified: 2007-12-19
Hi,

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
Good Question?
0
Question by:emmy21
    71 Solutions
    Best Solution byDLyall
    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 Symptoms Running a
    2 Comments
     
    71 Solutions

    Accepted Solution

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

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

    Cause
    FORMS90_PATH in default.env installed by iDS10g is not commented as in iDS9i.
    @ Bug:3315055 M21: FORMS90_PATH MUST BE COMMENTED OUT IN DEFAULT.ENV

    Solution
    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.
    Good Solution?
    0
     

    Author Comment

    by:emmy21
    Voila!
    Good Comment?
    0

    Add a Comment

    Join our community to follow up on this question and 4 million more solutions.

    Join & Write a Comment

    Featured Post

    Course: Foundations of Front-End Development

    Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

    Most Oracle programmers have heard of ROWIDs. Many have even used ROWIDs at some point. A few even have an idea of what the ROWID is, logically, but only a very select few actually know the details. It is sufficient to know that the ROWID exists and…
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    771 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

    28 Experts available now in Live!

    Get 1:1 Help Now