We help IT Professionals succeed at work.

Update Layout at a Oralce Forms

ee_lcpaa
ee_lcpaa asked
on
Medium Priority
415 Views
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.

Thanks.
Comment
Watch Question

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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.