• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

Update Layout at a Oralce Forms

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.

  • 2
2 Solutions
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.
ee_lcpaaAuthor Commented:
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.

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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now