Oracle 9i Qs: URL contains extra characters and how to maximize servelet

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Michael

    Oracle 9i Qs: URL contains extra characters and how to maximize servelet

    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\Frmma in&userid=user/password@databa se&buffer_recor ds=NO&debug_mes sages=NO&array= YES&query_only= NO&quiet=NO&REN DER=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.
  • Cedric Vonck

    #2
    Re: Oracle 9i Qs: URL contains extra characters and how to maximize servelet

    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.84fb 07d@posting.goo gle.com>...
    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\Frmma in&userid=user/password@databa se&buffer_recor ds=NO&debug_mes sages=NO&array= YES&query_only= NO&quiet=NO&REN DER=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.

    Comment

    • Michael

      #3
      Re: Oracle 9i Qs: URL contains extra characters and how to maximize servelet

      vanderhoeven@pi ng.be (Cedric Vonck) wrote in message news:<71aee92e. 0403010257.1a5f 379d@posting.go ogle.com>...
      Q1: unknown
      >
      <snip>
      >
      Regards,
      Cedric Vonck
      Thanks very much, Cedric, your solution works perfectly.
      >
      >
      google@m-streeter.demon. co.uk (Michael) wrote in message news:<a85e2cde. 0402260913.84fb 07d@posting.goo gle.com>...
      Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
      http://%%20" in front of the URL, like this:
      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\IEXPLO RE.EXE).

      Comment

      • Cedric Vonck

        #4
        Re: Oracle 9i Qs: URL contains extra characters and how to maximize servelet

        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_d irectory



        google@m-streeter.demon. co.uk (Michael) wrote in message news:<a85e2cde. 0403020559.71e1 0042@posting.go ogle.com>...
        vanderhoeven@pi ng.be (Cedric Vonck) wrote in message news:<71aee92e. 0403010257.1a5f 379d@posting.go ogle.com>...
        Q1: unknown
        <snip>

        Regards,
        Cedric Vonck
        >
        Thanks very much, Cedric, your solution works perfectly.
        >


        google@m-streeter.demon. co.uk (Michael) wrote in message news:<a85e2cde. 0402260913.84fb 07d@posting.goo gle.com>...
        Q1. Whenever I run my form, it starts MSIE OK, but puts the characters
        http://%%20" in front of the URL, like this:
        >
        >
        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\IEXPLO RE.EXE).

        Comment

        Working...