Forms 6i Setup

Posted on 2007-08-06
Last Modified: 2013-11-05
Hello All,

We are in the process of upgrading from 11.0.3 to 11.5.10 and now need to use Forms 6i instead of 4.5 to edit a couple of forms. In the past, I was able to ftp the fmb file over to my local machine, and place any attached PLL files or FMB files in the orant\FORMS45\PLSQLLIB directory so they were found when the file was opened.

Apparently this is not the case anymore. Can anyone give me a brief explanation of the best way to set this up on 6i, or at least guide me to the proper documentation? I've yet to find anything beneficial.

Question by:XOracle
    LVL 12

    Accepted Solution

    you have to make sure that all files opened with the fmb (pll, mmb) are accessible:

    1) copy the files in the same directory as fmb
    2) set the forms path enviroment before starting forms builder:
    SET FORMS60_PATH=C:\my_dir1;c:\my_dir2
    3) set the registry (HKLM --> Software --> Oracle --> FORMS60_PATH)

    also make sure that your attached pll's do not have a hardcoded path!

    Author Comment

    So I see in the registry where:

    I copied all of the attached FMBs into C:\orant\FORMS60, which fixed that issue, but I'm still having trouble with the PL/SQL library files. I have copied such files as APPCORE.pll to both of the above directories as well as the directory of the form in which I am currently working. I am also connected to the database, but still receive an:

    FRM-10102: Cannot attach PL/SQL library APPCORE. This library attachment will be lost if the module is saved.

    Any thoughts on what I am still doing wrong?

    Thanks again,
    LVL 22

    Expert Comment

    What happens if you attach APPCORE.pll to your form once again (remove path), close the form and open it ?
    I would recommend also compile all libraries.
    LVL 6

    Assisted Solution

    APPCORE.pll has references to other PLL Libraries.  It looks like you have copied only APPCORE.pll and not the rest of the libraries.  My suggestion would be to ftp all the libraries from the eBusiness to one of the local path that you have mentioned in FORMS60_PATH.


    Author Comment

    That did it. I went ahead and copied the entire PLL library over into the path that jwahl led me to and all is good. Thanks to all for your assistance.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    754 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now