Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Location
    Saudi Arabia
    Posts
    4

    Unanswered: Host command doesn't work well when i deploy the forms on application server?

    Hi dear.
    I am trying to open acrobat reader 5.0 through oracle forms 9i from the
    server by HOST COMMAND.It works fine locally but when I deploy the
    forms on application server that is middle tire then it doesn't work and
    even it doesn't give any error
    I used the following code.

    BEGIN
    ( Host('"\\Scthoap01\ADOBE\Acrobat 5.0\Acrobat\acrobat.exe"'|| acrobat_file||'.PDF
    END;

    Please note that Scthoap01 is the name of server where the acrobat reader 5.0 is installed.
    I shall be very thankful to u for this kindness.
    Your prompt response will be appreciated.
    Pls reply me on this address.

    javed@sct.gov.sa

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    HOST is a SQL*Plus command, not an Oracle-wide command. It only works in SQL*Plus client. It cannot be used in PL/SQL blocks, which are executed on the sever and not in your SQL*Plus client.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Please do a reality check.
    Forms 9i are WEBFORMS;
    which means even if you get Acrobat to launch,
    you are faced with the small problem of getting
    the results displayed by the PC's browser.
    It can be done, but not anywhere close to how
    you are attempting to do it.

  4. #4
    Join Date
    Dec 2003
    Location
    Saudi Arabia
    Posts
    4

    Clearification

    Respected Sir,
    A lot of thanks for ur response.Yes thes are web forms 9i. As i descirbed in my previous message that it works fine when i open acrobat reader from server in my PC.But when i deploy that form on Server then it doesnt open the acrobat reader.
    Pls advise me , Is there any other method to open an external program from forms 9i that we can implement on application server 9iAS.
    Thank you once again for ur co-opertaion.
    Waiting for ur reply.
    Thanks
    Javed

  5. #5
    Join Date
    Dec 2003
    Location
    Saudi Arabia
    Posts
    4

    Clearification.

    Respected Sir,

    A lot of thanks for ur response.Yes thes are web forms 9i.I think u couldn't understand my question. As i descirbed in my previous message that it works fine when i open acrobat reader from server in my PC.But when i deploy that form on Server then it doesnt open the acrobat reader.
    Pls advise me , Is there any other method to open an external program from forms 9i that we can implement on application server 9iAS.
    Thank you once again for ur co-opertaion.
    Waiting for ur reply.
    Thanks
    Javed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •