DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Displaying Document from WEB Urgent!!!!!!!

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    Hi All,

    I have loaded a Word Document into a BLOB column. We are devleoping an application using Web Forms.
    From the client if the user hits a button the document which is loaded into the table should be
    opened in Word.

    Is this possible to do with PL/SQL

    Anyhelp will be appreciated.

    Thanks.
    Vijay.
    Say No To Plastics

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    NOBODY??
    Say No To Plastics

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    You did not say what the client software or os was, but generally speaking, yes it is possible.

    Your PL/SQL would have to fetch the BLOB, put it in a temporary file (or clipboard) and then start Word with that file name, I believe.

    At least this is the technique (or close to it) I used back in forms 2 and forms 3.

    If your OS is not Winxx, word won't run, but you might be able to use StarOffice.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jrpm
    You did not say what the client software or os was, but generally speaking, yes it is possible.

    Your PL/SQL would have to fetch the BLOB, put it in a temporary file (or clipboard) and then start Word with that file name, I believe.

    At least this is the technique (or close to it) I used back in forms 2 and forms 3.

    If your OS is not Winxx, word won't run, but you might be able to use StarOffice.
    In Forms 3 there was no PL/SQL, forget about BLOB datatypes :-)

    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by julian
    In Forms 3 there was no PL/SQL, forget about BLOB datatypes :-)
    You probably ment to say: "In Forms 2 there was no PL/SQL,....".

    In Forms 3 shure there was PL/SQL, it was PL/SQL rel.1.0.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by jmodic
    Originally posted by julian
    In Forms 3 there was no PL/SQL, forget about BLOB datatypes :-)
    You probably ment to say: "In Forms 2 there was no PL/SQL,....".

    In Forms 3 shure there was PL/SQL, it was PL/SQL rel.1.0.
    Yep, Forms 2 of course.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Since it is a Web-application, the client is Browser.
    Oracle Version: 8.1.5
    Oracle Developer 6i.
    Web Server: IIS.

    Thanks
    Vijay.
    Say No To Plastics

Posting Permissions

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


Click Here to Expand Forum to Full Width