OraFAQ Forum: Forms » DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error

Home » Developer & Programmer » Forms » DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error (Forms10g,applicationserver10G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DDE.DMLERR_NOTPROCESSED -TRANSACTION FAILED error [message #358482]

Tue, 11 November 2008 09:34

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