Home » Developer & Programmer » Forms » DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error (Forms10g,applicationserver10G)
DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error [message #358482] Tue, 11 November 2008 09:34 Go to next message
jebesh_s
Messages: 34
Registered: August 2007
Location: Chennai
Member
Dear Gurus,

I have written the below coding while running this it shows
DDE.DMLERR_NOTPROCESSED A TRANSACTION FAILED error
please help me to resolve the issue.i can not guess the reason for this error.pls find the uploaded screen short

DECLARE
AppID PLS_INTEGER;
convID PLS_INTEGER;
excel_path varchar2(400);
virtual_path varchar2(400);
storage_path varchar2(400);
Buffer varchar2(2000);
BEGIN
message('before executing dde.app_begin');
--AppID := DDE.App_Begin('C:\Program Files\Microsoft Office\OFFICE11\excel.exe http://10.192.30.56:81/excel/xls4.xls',DDE.APP_MODE_MINIMIZED);
AppID := DDE.App_Begin(:EXCEL_PATH||' '||:VIRTUAL_PATH,DDE.APP_MODE_MINIMIZED);
message('after dde.app_begin & before executing dde.initiate');
--ConvID :=DDE.Initiate('EXCEL', 'http://10.192.30.56:81/excel/xls4.xls');
ConvID :=DDE.Initiate('EXCEL', :VIRTUAL_PATH);
message('after dde.initiate');
DDE.Request(ConvID, 'R2C2:R3C4', Buffer, DDE.CF_TEXT,1000);
message('after request');
message('Success Success');message('Success Success');

EXCEPTION
WHEN DDE.DDE_APP_FAILURE THEN
MESSAGE('WINDOWS APPLICATION CANNOT START.');
MESSAGE('DDE CANNOT ESTABLISH A CONVERSATION');
WHEN DDE.DDE_PARAM_ERR THEN
MESSAGE('A NULL VALUE WAS PASSED TO DDE');
MESSAGE('DDE CANNOT ESTABLISH A CONVERSATION');

WHEN DDE.DMLERR_NO_CONV_ESTABLISHED THEN
MESSAGE('DDE CANNOT ESTABLISH A CONVERSATION');
MESSAGE('DDE CANNOT ESTABLISH A CONVERSATION');

WHEN DDE.DMLERR_NOTPROCESSED THEN
MESSAGE('A TRANSACTION FAILED');
MESSAGE('A TRANSACTION FAILED');


END;


Advance Thanks


Thanks & Regards
Jebesh
Re: DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error [message #358565 is a reply to message #358482] Tue, 11 November 2008 20:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you considered using 'ole2'? See http://www.orafaq.com/forum/m/277805/67467/?srch=excel#msg_277805

David
Previous Topic: How to get temporary internet files path
Next Topic: populating list items from existing record groups
Goto Forum:
  


Current Time: Fri Dec 09 07:54:56 CST 2016

Total time taken to generate the page: 0.18171 seconds