-
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
-
-
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'
-
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
-
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?
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|