Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
http://%%20" in front of the URL, like this:

http://%%20"http://W18670:8888/forms90/f90servlet?form=C:\ANPR\Source_v2\Forms\Frmmain&us erid=user/password@database&buffer_records=NO&debug_messages =NO&array=YES&query_only=NO&quiet=NO&RENDER=YES"

Every time I run the form, I have to delete these 12 characters from
the front of the URL and hit enter and it runs fine. Why? I have
checked all the set up options I can find, and I have searched the
registry and in every Oracle file on the system for 'http:/' and I
can't find it anywhere.

Can anybody suggest some things to try?

Q2. When the Java servelet runs, there is a grey bar across the top of
the applet with the Oracle logo on the right hand side. Some of my
forms are bigger than the applet window, in which case I get scroll
bars. Does anybody know whether I can maximize the applet to take up
the full web browser screen? Alternatively, can I run the servlet not
using MSIE but just in a window?

I have been trying to find some good books on Forms 9i or information
on the net. Can anybody recommend some resources? I have the Oracle
Press Oracle 9i Complete Reference, but it only covers SQL and PL/SQL
which is not so much use to me. There doesn't seem to be much around
eg. on Amazon about Forms 9i.

Thank you very much for any help you can give.

google@m-streeter.demon.co.uk (Michael) wrote in message news:<a85e2cde.0402260913.84fb07d@posting.google.c om>...[color=blue]
> Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
> http://%%20" in front of the URL, like this:
>
> http://%%20"http://W18670:8888/forms90/f90servlet?form=C:\ANPR\Source_v2\Forms\Frmmain&us erid=user/password@database&buffer_records=NO&debug_messages =NO&array=YES&query_only=NO&quiet=NO&RENDER=YES"
>
> Every time I run the form, I have to delete these 12 characters from
> the front of the URL and hit enter and it runs fine. Why? I have
> checked all the set up options I can find, and I have searched the
> registry and in every Oracle file on the system for 'http:/' and I
> can't find it anywhere.
>
> Can anybody suggest some things to try?
>[/color]

I should add to what I have put above that I have the form open in
Oracle Forms Builder to begin with. I am pressing F5 (or click on
Programs, Run Form) in order to run it, and that is how MSIE gets
started.

Thanks for any help.

Q1: unknown

Q2: Try the following

in formsweb.cfg file in /OraHome1/Form90/server Directory.
-width is 720
-height is 700
adapt these parameter & bounce Apache (start & stop)

Regards,
Cedric Vonck


google@m-streeter.demon.co.uk (Michael) wrote in message news:<a85e2cde.0402260913.84fb07d@posting.google.c om>...[color=blue]
> Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
> http://%%20" in front of the URL, like this:
>
> http://%%20"http://W18670:8888/forms90/f90servlet?form=C:\ANPR\Source_v2\Forms\Frmmain&us erid=user/password@database&buffer_records=NO&debug_messages =NO&array=YES&query_only=NO&quiet=NO&RENDER=YES"
>
> Every time I run the form, I have to delete these 12 characters from
> the front of the URL and hit enter and it runs fine. Why? I have
> checked all the set up options I can find, and I have searched the
> registry and in every Oracle file on the system for 'http:/' and I
> can't find it anywhere.
>
> Can anybody suggest some things to try?
>
> Q2. When the Java servelet runs, there is a grey bar across the top of
> the applet with the Oracle logo on the right hand side. Some of my
> forms are bigger than the applet window, in which case I get scroll
> bars. Does anybody know whether I can maximize the applet to take up
> the full web browser screen? Alternatively, can I run the servlet not
> using MSIE but just in a window?
>
> I have been trying to find some good books on Forms 9i or information
> on the net. Can anybody recommend some resources? I have the Oracle
> Press Oracle 9i Complete Reference, but it only covers SQL and PL/SQL
> which is not so much use to me. There doesn't seem to be much around
> eg. on Amazon about Forms 9i.
>
> Thank you very much for any help you can give.[/color]

vanderhoeven@ping.be (Cedric Vonck) wrote in message news:<71aee92e.0403010257.1a5f379d@posting.google. com>...[color=blue]
> Q1: unknown
>[/color]
<snip>[color=blue]
>
> Regards,
> Cedric Vonck[/color]

Thanks very much, Cedric, your solution works perfectly.
[color=blue]
>
>
> google@m-streeter.demon.co.uk (Michael) wrote in message news:<a85e2cde.0402260913.84fb07d@posting.google.c om>...[color=green]
> > Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
> > http://%%20" in front of the URL, like this:
> >[/color][/color]

OK, I have the answer to that one:
In Oracle Forms, click on Edit, Preferences.
Click on the Runtime tab and completely specify
the Application Server URL (e.g. http://W18670:8888/forms90.f90servlet)
and the Web Browser Location (e.g. C:\Program Files\Internet Explorer\IEXPLORE.EXE).

No problemo mate! :-)
Btw, I looked this up at Metalink.
Unfortunately I cannot distributed my login // pwd or my company could
loose his oracle support.

If you have any questions, don't hesitate to post them!.

I have thought a bit about Q1:
I think that is related to IE.
Login as Administrator
goto the dos prompt
cd "Documents and settings"
cd "<user>"
cd "Local Settings"

delete "History" & Temporary Internet Folder

and reboot.

You have also be carefull with the directory you put your forms in!!
Make sure that there are NO spaces tabs or other control characters
in..
Otherwise you will bump into another 9000 error.

And thirdly, if you wish to use the forms in another language, like
me, in Dutch.

Go to the register,
Go the Oracle Home of Forms
Add or adapt the NLS_LANGUAGE parameter
Reboot is prefferred.

Fourthly,
To work convienently with menus, you have to set the correct path
to your forms directory:

Register
Oracle Home of forms
Add or adapt the following parameter: forms_path
edit the key and reboot (always be on the safe side)

forms_path => c:\oracle.....\;c:\my_forms_directory



google@m-streeter.demon.co.uk (Michael) wrote in message news:<a85e2cde.0403020559.71e10042@posting.google. com>...[color=blue]
> vanderhoeven@ping.be (Cedric Vonck) wrote in message news:<71aee92e.0403010257.1a5f379d@posting.google. com>...[color=green]
> > Q1: unknown
> >[/color]
> <snip>[color=green]
> >
> > Regards,
> > Cedric Vonck[/color]
>
> Thanks very much, Cedric, your solution works perfectly.
>[color=green]
> >
> >
> > google@m-streeter.demon.co.uk (Michael) wrote in message news:<a85e2cde.0402260913.84fb07d@posting.google.c om>...[color=darkred]
> > > Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
> > > http://%%20" in front of the URL, like this:
> > >[/color][/color]
>
> OK, I have the answer to that one:
> In Oracle Forms, click on Edit, Preferences.
> Click on the Runtime tab and completely specify
> the Application Server URL (e.g. http://W18670:8888/forms90.f90servlet)
> and the Web Browser Location (e.g. C:\Program Files\Internet Explorer\IEXPLORE.EXE).[/color]