Solved

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

Posted on 2005-08-25
2
6,507 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
0
Comment
Question by:emmy21
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
DLyall earned 500 total points
ID: 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.
0
 

Author Comment

by:emmy21
ID: 14752197
Voila!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
add more rows to hierarchy 3 48
PL/SQL: ORA-00979: not a GROUP BY expression 3 84
Migration from sql server to oracle 5 51
Error 14 initializing SQL*Plus 4 22
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

710 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