Link to home
Start Free TrialLog in
Avatar of hawarat
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.
Avatar of Avotar
Avotar

you could check:
- 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
ASKER CERTIFIED SOLUTION
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hawarat

ASKER

Markgeer has touched the problem exactly, I think he has a very deep sense of Oracle!

Many Thanks