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

    Question by:
    On

    Topics:

    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
     

    ?

    The member who asked this question verified this comment provided the solution that solved their problem.

    Accepted Solution on 2005-08-25 at 07:11:20ID: 14752142

    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.

    Top Expert Contributor

    Essential articles and videos from the Experts

    More valuable questions with Expert answers

    201511-LO-Qu-074

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    sdstuber

    14

    Articles

    Expert in:

    • Oracle Database
    • Query Syntax
    • Databases
    • Enterprise Software
    • MS SQL Server

    slightwv

    Expert in:

    • Oracle Database
    • Databases
    • Query Syntax
    • Linux
    • Unix OS

    johnsone

    Expert in:

    • Oracle Database
    • Databases
    • Query Syntax
    • Linux
    • Unix OS

    Wasim Akram Shaik

    2

    Articles

    Expert in:

    • Oracle Database
    • Databases

    Gerwin Jansen

    5

    Articles

    Expert in:

    • Linux
    • Unix OS
    • Linux Distributions
    • Oracle Database
    • Scripting Languages

    Steve Wales

    5

    Articles

    Expert in:

    • MS SQL Server
    • Oracle Database
    • MS SQL Server 2008
    • Databases
    • MS SQL Server 2005

    Kdo

    2

    Articles

    Expert in:

    • C
    • DB2
    • MySQL Server
    • C++
    • Databases

    Docteur_Z

    Expert in:

    • Oracle Database

    Dan McFadden

    Expert in:

    • Microsoft IIS Web Server
    • Windows Server 2008
    • Windows Server 2012
    • ASP.NET
    • Active Directory

    RELATED TOPICS view all topics

    1. Query Syntax
      (46,075)
    2. Databases
      (52,988)
    3. MS SQL Server
      (154,649)
    4. Unix OS
      (33,012)
    5. Enterprise Software
      (5,604)
    6. Linux
      (64,223)
    7. Java
      (98,149)
    8. .NET Programming
      (131,080)
    9. MS SQL Server 2005
      (71,588)
    10. MySQL Server
      (45,789)