Update Layout at a Oralce Forms

Posted on 2009-02-10
Last Modified: 2013-12-18
Hi all,

I'm using Oracle Forms 10g to update an existing oracle Forms. I just want to add a textbox onto this Form. I found that this textbox does not exist on the updated Forms when I load it one of my Oracle databases.

But it is okay if I upload this form to another testing database.

I would like to know if there is any cache at the oracle server side such that I need to clean it up to force it to reload the updated form.

Question by:ee_lcpaa
    LVL 16

    Accepted Solution

    Maybe I'm showing my ignorance but I wasn't aware that you could store forms in the database.  Just started Forms Builder 10g and can't see any options to open a form that is stored in the database so I'm not quite sure what you mean when you say:

    ""...when I load it one of my Oracle databases."
    "...upload this form to another testing database."

    Are you meaning that you run the form and connect to a database?  In my experience of forms 10g, the forms are stored as fmb files, not in the database and there is no cache that I'm aware of.

    Author Comment

    If I ran the updated forms with Forms Builder 10g, I could what I had updated.

    I have one production server & one testing server. Both of them had installed Forms service.

    But if I upload the fmb file to a specified path to the production server, I could not see what I had changed.

    On the other hand, I could see what I had changed at the testing server. Hoep this is clear.

    LVL 16

    Assisted Solution

    I assume you are running the forms as webforms and not from the forms builder.

    It sounds like the forms server is loading the form from a specific directory, so you need to put your changed form into that directory.  To determine which directories the forms server runs forms from you need to look at the formsweb.cfg and environment file (this will be called default.env its name hasn't been changed).

    The formsweb.cfg file in the $ORACLE_HOME/forms/server directory will identify an environment file to use.  If the standard environment file is used this will be called default.env.  If a bespoke file is being used then look for the envfile in formsweb.cfg and this will identify the name of the file.  The environment file will have an extension of .env and will usually be in the same directory as the formsweb.cfg file.  This environment file will set the FORMS_PATH environment variable which is used to search for the form to be run.  Ensure your modified form exists in one of the directories listed in FORMS_PATH and that an older form with the same name doesn't.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to recover a database from a user managed backup

    755 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

    17 Experts available now in Live!

    Get 1:1 Help Now