|
|
|
|
|
|
| Re: To open word document/excel/pdf from Oracle forms [message #312224 is a reply to message #308716] |
Tue, 08 April 2008 04:27   |
taofiksadiku
Messages: 1
Registered: April 2008
Location: United Kingdom
|
Junior Member |
|
|
Does anyone how to easily open a word document from Oracle Forms Builder?
I'v used the following code:
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\Office10\WINWORD.EXE C:\forms\Forms\FORMS_CODE.DOC',DDE.APP_MODE_NORMAL);
end;
When the button is clicked to open the document, I get the message:
ORA106500:WHEN-BUTTON-PRESSED raised unhandled exception.
Does anyone know the cos of this problem? Pls let me hear from you if you do. Many thanks.
Taofik
|
|
|
|
|
|
|
|
|
|
|
|
| Re: To open word document/excel/pdf from Oracle forms [message #336209 is a reply to message #312224] |
Fri, 25 July 2008 03:48 |
saini006
Messages: 9
Registered: July 2008
Location: hyderabad
|
Junior Member |
|
|
hello
can you help me
how can i open os file from forms 6i
i want to open os file when button pressed trigger
here i am using some code but i unable to open with this
declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin(:REPORT_LOCATION,DDE.APP_MODE_NORMAL);
end;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: To open word document/excel/pdf from Oracle forms [message #426490 is a reply to message #361744] |
Thu, 15 October 2009 22:49 |
rakesh1901
Messages: 12
Registered: November 2007
Location: Vadodara,India
|
Junior Member |
|
|
i want to open a word/excel/pdf file using forms 10g which is saved in database server...... so that client can not save that file,can not select its text,and can not do copy paste.
means just read,nothing else.
it doesn't matter that it will open to client machine or on server.
so how can i do this?
|
|
|
|
| Re: To open word document/excel/pdf from Oracle forms [message #426492 is a reply to message #361744] |
Thu, 15 October 2009 22:51 |
rakesh1901
Messages: 12
Registered: November 2007
Location: Vadodara,India
|
Junior Member |
|
|
i want to open a word/excel/pdf file using forms 10g which is saved in database server...... so that client can not save that file,can not select its text,and can not do copy paste.
means just read,nothing else.
it doesn't matter that it will open to client machine or on server.
so how can i do this?
we are using MS Windows Server 2003 R2.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: To open word document/excel/pdf from Oracle forms [message #584603 is a reply to message #580609] |
Thu, 16 May 2013 02:31 |
katangur.nikethan
Messages: 31
Registered: December 2009
Location: Hyderabad
|
Member |
|
|
Hi all,
I need to Open a file which is stored in the Data base Table & the Data type is of BLOB so i am populating the data but i need to display the attachment which is stored in the BLOB file when the button is clicked
I have been using the below code to do so but it's not getting worked
------------------------------------------------------------------
DECLARE
vblob BLOB;
vmime VARCHAR2(30);
BEGIN
select attachment,MIME_TYPE into vblob,vmime
from Table_name_a
where UNIQUE_ID = 16842;--:ITEM_RESULT.DRAWINGNO;
htp.init;
owa_util.mime_header( vmime, false);
-- owa_util.mime_header( 'image/jpeg', false);
-- owa_util.mime_header( 'image/jfif', false);
-- owa_util.mime_header( 'image/gif', false);
-- owa_util.mime_header( 'application/word' , FALSE);-- to read MS WORD doc
owa_util.mime_header( 'application/pdf' , FALSE);-- to read ADObE
message ('attachment type is' ||vmime);
message ('attachment type is' ||vmime);
owa_util.http_header_close;
wpg_docload.download_file(vblob);
exception
when no_data_found then
dbms_output.put_line('1. attachment type is' ||vmime);
-- NULL;
end;
-------------------------------------------------------------------
so if any body has any idea Please let me Know,it's Much Urgent for me.
Hope for the Earliest Reply.
Thanks & Regards
K Nikethan Reddy
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
