Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How do I run a Form from local host?
How do I run a Form from local host? [message #251743] Mon, 16 July 2007 08:07 Go to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Dear all!

The Oracle Developer Suite 9 setup progressing completed successfully, OC4J, Oracle HTTP server and the relative others started normally. But when I executed a form with IE, it did not display.

I knew that, the OC4J Instant must be started before I compile a form, and following the URL if running with 3 tier:

<url>http:<middle-tier application server>:<OC4J port>/forms90/f90servelet</url>

But it's for 3 tier topology, unfortunately, I run it from my PC.

Please guide me to configure it on my local host.

Thank you very much!

Re: How do I run a Form from local host? [message #251793 is a reply to message #251743] Mon, 16 July 2007 12:18 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You can install all tiers on the same machine. Either check the host name you entered when installing the sw. It may have insisted on a fully qualified host name (abc.mycorp.com or whatever). On Unix, this qould include "hosts" file and a bunch of others - check the docs.

If localhost doesn't work, try 127.0.0.1
How do I run a Form from local host? [message #252146 is a reply to message #251743] Tue, 17 July 2007 23:36 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for the answer!

These are the detail problems following:

- My OS is Windows XP, Oracle Database is 9.2.0.1, Oracle Developer Suite (includes AS) 9. All of them were installed on the same machine which named as OraDBA, it's also my host name.

- The OC4J Instance started successfully before running a form. You can see the image attached following

http://i95.photobucket.com/albums/l130/trantuananh24hg/OC4J_Instance.jpg

- The Application Server URL is "http://oradba:8888/forms90/f90servlet" , and web-browser is IE 7.

- I create a db_block by wizard for schema scott with only 2 table in form named EMP and ENAME. The layout of EMP db_block is attached following.

http://i95.photobucket.com/albums/l130/trantuananh24hg/layout_db_block_EMP.jpg

- Then, nothing to add with code by any trigger or procedure. So, I want to view how did this form run. But, it did not display. Please look at the last image attached.

http://i95.photobucket.com/albums/l130/trantuananh24hg/RunningwithIE.jpg

How do I solve it?

Thank you very much!
Re: How do I run a Form from local host? [message #252301 is a reply to message #252146] Wed, 18 July 2007 09:36 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Is there a space sign in the directory name? If so, try to save a .FMB file into a different directory, which does NOT have a space in its name.

For example, if this form is in "c:\my documents\my forms", change it to "c:\my_forms". Don't forget to add this directory into the FORMS90_PATH in the registry!
Re: How do I run a Form from local host? [message #252310 is a reply to message #251743] Wed, 18 July 2007 10:13 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
@Little Foot: I checked according to your guide, it's indeed, the directory contained form which named as Form Builder has a space, then I rewrote. It-the form ran successfully.

Thank you very much LittleFoot, I love you! Smile
Re: How do I run a Form from local host? [message #252322 is a reply to message #252310] Wed, 18 July 2007 11:06 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I love myself too, so what? Smile

I'm glad you solved the problem!
Previous Topic: Alter UTL_HTTP Timeout
Next Topic: Shell Script in HTMLDB
Goto Forum:
  


Current Time: Wed Dec 04 19:41:37 CST 2024