Oracle Forms (MOSC)

MOSC Banner

Issue While generating Excel reports Using 9ias

edited Feb 25, 2010 7:48PM in Oracle Forms (MOSC) 8 commentsAnswered
Hi,

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)]';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center