Issue While generating Excel reports Using 9ias
While we migrated from 9ids to 9ias the excel reports generated from the application using dde.app_begin is not getting executed. the same code is working using 9ids.
Sample of the code is given below.
Declare
APPID PLS_INTEGER;
CONVID PLS_INTEGER;
str Varchar2(5000);
str1 Varchar2(5000);
ls_terminal varchar2(200);
Path varchar2(300);
Begin
APPID := DDE.APP_BEGIN('C:\Program Files\Microsoft Office\Office11\excel.exe',dde.app_mode_normal);
CONVID := DDE.INITIATE('EXCEL','system');
path := 'c:\'||'GCI_grn_REGIS_VAL_'||to_char(sysdate,'ddmmyyyy_hhmiss')||'_'||'x'||'.xls';
str := '[save.as("'||path||'",1)]';