hawarat
asked on
Cannot attach library %s while opening form %s.
I'm trying to attach a library to a form, when I'm compiling it everything goes alright, but when I'm running it the following error appears: (FRM-40039)
Cannot attach library MY_LIB while opening form MY_FORM.
what is going on, taking in mind that the schema is prepared to store a library by runing the designated scripts by oracle tools, the paths for the pll and plx are correct, and the library could be opened, modified, generated and saved.
here are the details of the error:
FRM-40039: Cannot attach library %s while opening form %s.
Cause:The given library is attached to the form but cannot be located in the search path for PL/SQL libraries.
Action: Make sure that the given library can be found and that it has read permissions set.
Cannot attach library MY_LIB while opening form MY_FORM.
what is going on, taking in mind that the schema is prepared to store a library by runing the designated scripts by oracle tools, the paths for the pll and plx are correct, and the library could be opened, modified, generated and saved.
here are the details of the error:
FRM-40039: Cannot attach library %s while opening form %s.
Cause:The given library is attached to the form but cannot be located in the search path for PL/SQL libraries.
Action: Make sure that the given library can be found and that it has read permissions set.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Markgeer has touched the problem exactly, I think he has a very deep sense of Oracle!
Many Thanks
Many Thanks
- your registry if the path forms runtime uses contains your library.
- there any "hard" paths in your forms that cannot be found at runtime.
- that if you use multiple libs... you can convert them to text and see if there are any hardcode directories there.
good luck.
Rick