Excel-data with Oracle Forms

From: Roland Kopetzky <kopetzky_at_ike.uni-stuttgart.de>
Date: Mon, 4 Jan 1999 12:01:23 +0100
Message-ID: <76q75v$rt6$1@infosun2.rus.uni-stuttgart.de>

Hi all,

I have a problem reading Excel-data with Oracle Forms. I see the excel-sheet open and then the focus is set back to Oracle Forms but then an error appears.
Can you please tell me what I am doing wrong?

Here is my Code for interface between Oracle Forms 4.5 and MS Excel (Office 97)
running under Windows NT 4.0 Service pack 4

DECLARE
app_name Varchar2(255);

  app_id     PLS_INTEGER;
  name       VARCHAR2(100);
  file_name  VARCHAR2(100);
  buffer     CHAR(100);

BEGIN
if :GLOBAL.application_id is NOT NULL then Message ('Anwendung Excel schon gestartet'); else
Message ('Anwendung Excel wird gestartet'); app_name := 'C:\PROGRA~1\MICROS~1\OFFICE\EXCEL.EXE'; file_name := 'C:\TEMP\TESTXLS.XLS'; name := app_name || ' ' ||file_name; app_id := DDE.APP_BEGIN(name, DDE.APP_MODE_NORMAL); DDE.Request (app_id, 'R3C2', Buffer, DDE.CF_TEXT, 1000);

DDE.APP_END (app_id);
end if;

EXCEPTION
  when dde.dde_app_FAILURE then
    MESSAGE('Konnte Anwendung für DDE nicht starten.');     RAISE FORM_TRIGGER_FAILURE;
  when others then
    MESSAGE ('FEHLER: '||to_char(sqlcode)||' '||sqlerrm);     RAISE FORM_TRIGGER_FAILURE;
END; When I execute this, the application runs to error in the dde.request statement.
Fehler: -106553 106553: non-Oracle exception

The value of R3C2 which is C2:C2 is 6.0 (numerical).

What is going wrong here?

Please answer in the news or email to tischendorf_at_arkusa.de

Thank you.

Manfred Tischendorf Received on Mon Jan 04 1999 - 05:01:23 CST