[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 393
  • 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.

Thanks.
0
ee_lcpaa
Asked:
ee_lcpaa
  • 2
2 Solutions
 
MilleniumaireCommented:
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.
0
 
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.

0
 
MilleniumaireCommented:
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.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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