asked on

FRM-40039: Cannot attach library %s while opening form %s.

Now I've read the action to take:

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.

But where would this search path be located?

Here's my environment:

PC: HP/Compaq
O/S: Windows XP Pro (Service Pack 2)
Oracle Forms: Version 9.0.2.7.0
Oracle Database: 8.1.7.4.0

Thanks,
Gio

jaramill

ASKER

I figured out how to get rid of the error but it involves leaving the non-portable path/directory structure in there. I'd still like to know where I find the path for the PL/SQL Libraries.

Gio

sapnam

Either you leave the non-portable path while attaching the library or you do not attach it and mention the path in the Windows Registry in the Hkey--Local Machine--Software--Oracle registry. I think it should be in the forms path key.

ASKER CERTIFIED SOLUTION

sapnam

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jaramill

ASKER

Well I have my library in the directory of where the FMX is executed via the browser (both the PLL, and PLX). So when you say Form Builder searches the current directory are you saying it searches the directory where the Forms Runtime/WebRuntime executable exists? (i.e. forms\bin) or the current directory of where the fmx file is located (which can be anywhere the user has the fmx files)?

Thanks,
Gio

jaramill

ASKER

Just updated the FORMS90_PATH registry variable and it worked great "sapnam".

Thanks,
Gio