Excel-Data with Oracle Forms
Date: Mon, 4 Jan 1999 12:02:06 +0100
Message-ID: <76q77a$rve$1_at_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 - 12:02:06 CET