| frm - 40039 can't attach PL/SQL Library [message #142898] |
Tue, 18 October 2005 05:18  |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
hi
i have attached a pl/sql library to my oracle form 10g.
In default.env file set the value of FORMS90_PATH.
After attaching library if i clicks "yes" in "remove path alert" option and run the form , it works fine but next time on opening the same .fmb file, library attachment is lost with FRM-10202 message that can't attach library.
But if i clicks "no" in "remove path alert" and run the form, error occurs that can't attach library(FRM - 40039).
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #143074 is a reply to message #142898] |
Wed, 19 October 2005 00:35  |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
yes u r right but i have set the FORMS90_PATH to D:\lib (location of my library) on my machine.
i have also set FORMS90_PATH in default.env file for server runtime environment to D:\Apps\Lib (location of .plx file of library)
when i deploy the form on server and access it from client machine, runtime error message occurs
FRM:40039 : Can't attach library D:\lib\mylib while opening form..
Now i think the problem is 'the path of lib on which the form was designed is different from application server path'
What should i do now.
|
|
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #143080 is a reply to message #142898] |
Wed, 19 October 2005 00:53 |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
when i select "yes" to remove the path then whenever next time i open the .fmb file library attachment is lost.
If i select no runtime error occurs that can't attach library when i deploy application on server.
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #143083 is a reply to message #142898] |
Wed, 19 October 2005 01:06 |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
now you mean that at the time of development i attach library and set remove path to "Yes" .
When i deploy the application then i just only place .plx files on server and set default.env (set FORMS90_PATH to the location of library plx file)?????
if your answer is yes then
what should i do when i again open the .fmb file for some changes and have to bear the burden of again setting library path due to lost of library.????
|
|
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #143089 is a reply to message #143083] |
Wed, 19 October 2005 01:12 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I said| Quote: |
I VERY STRONGLY suggest that you ONLY have a SINGLE development directory on your PC and it contains ALL the pll and plx files (not just the ones you are changing but a copy of ALL the plls used by your system), ALL the object library files, and the various forms and reports that you are developing.
|
please read this again ... it contains the answer to your question.
By the way, deploy is either AS or DS, not Forms. Is this a production system or an assignment to be run on a PC for assessment?
Okay ... we overlapped on answers.
David
[Updated on: Wed, 19 October 2005 01:12] Report message to a moderator |
|
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #143103 is a reply to message #142898] |
Wed, 19 October 2005 01:49 |
s4sam
Messages: 18
Registered: October 2005
Location: pakistan
|
Junior Member |
|
|
I am using 10g forms and AS on windows plateform for deployment.
Now i have placed all the libraries in a sigle directory on D:\Lib on my machine for development.
Also on application server i have made a directory D:\Lib with all the .plx files of libraries .
Also set default.env's FORM90_PATH to D:\Lib on application server.
now since path for library on my machine & on applicatin server is same thus no problem in library attachment.
All this is done with ur help. Thanks for you valuable time for me. Thans once again
|
|
|
|
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #395147 is a reply to message #143052] |
Tue, 31 March 2009 08:27 |
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
|
Senior Member |
|
|
What u mean by register?
I can understand your meaning.
please sir me detail steps.
I create .pll and saved it in D:\library.
now where i put this D:\library either in envir variable or where?
I am working in form 10g.
In envire variable there is Forms_path not Forms90_path both are same.
I am waiting form +ve response.
Thanks
|
|
|
|
|
|
| Re: frm - 40039 can't attach PL/SQL Library [message #668898 is a reply to message #395568] |
Wed, 21 March 2018 03:39 |
 |
Atreide
Messages: 2
Registered: September 2015
Location: Bilbao
|
Junior Member |
|
|
Sorry, clicked on the mentioned link but got no where.
Concerning FORMS_PATH parameter in REGEDIT. For Developer Suite 10g I have FORMS_PATH variable not FORMS90_PATH Is this right? Shall I add a FORMS90_PATH variable to REGEDIT (KEY_DevSuiteHome1)? (For FORMS - DESIGNER 6I I have FORMS60_PATH variable in Regedit).
Well, I have the same problem about running the form I keep on getting FRM-40039. I created a ShortCut to start from the directory where the libraries are, I unattached all the libraries, compiled, generated, save them an reattach and I really find no way to get ride of this error even though the forms compiles and generates whith no problem.
Thank you in advance.
[Updated on: Wed, 21 March 2018 03:41] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
