Home » Developer & Programmer » Forms » ora-106555 (10g,Forms6i-Windows XP)
ora-106555 [message #308461] Mon, 24 March 2008 07:34 Go to next message
kernel
Messages: 3
Registered: March 2008
Junior Member
Hi, i want export to excel from form.

Code is working for Office xp but not working with office 2003.

the error code is ora-106555...

I searched but found nothing to do.
Can you help me?


PROCEDURE EXCEL IS

erow number(12):=2;
AppID PLS_INTEGER;
path varchar2(200);
ConvID PLS_INTEGER;

BEGIN

erow := 2;
win_api_utility.Copy_File('c:\urt_rapor_genel.xls','c:\Genel\urt_rapor_genel.xls',true, FALSE);
path := win_api_environment.Read_Registry('HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS\CURRENTVERSION\APP PATHS\EXCEL.EXE','PATH',FALSE);
AppID := DDE.App_Begin(path||'Excel.exe c:\Genel\urt_rapor_genel.xls',DDE.App_Mode_minimized);
win_api_utility.sleep(1000);
ConvID := DDE.Initiate('Excel.exe',C:\Genel\urt_rapor_genel.xls');

FOR XREC1 IN (
select ut.id,ut.tarih,ut.aciklama from urt_uretim_rapor ut
where ut.id = :urt_uretim_rapor.id
)

LOOP

message(xrec1.id);
DDE.Poke(ConvID, 'R3A1','KAYIT NO :', DDE.CF_TEXT, 10000);
end loop;
end;

[Updated on: Mon, 24 March 2008 07:38]

Report message to a moderator

Re: ora-106555 [message #309234 is a reply to message #308461] Wed, 26 March 2008 19:19 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at:
Working with Excel via OLE2
http://www.orafaq.com/forum/t/72811/67467/
http://www.orafaq.com/forum/m/84230/67467/
Merge two cells in Excel using ole2
http://www.orafaq.com/forum/t/77825/67467/
Error closing Excel file generated using OLE2
http://www.orafaq.com/forum/t/77351/67467/
How to wrap text in excel cell using ole2
http://forums.oracle.com/forums/thread.jspa;jsessionid=8d92200830d62336f40f5aad44efb36ee981f4e6c19e.e34QbhuKaxmMai0MaNeMb3eKb390?mess ageID=1242535&#1242535
Excel via DDE
http://www.orafaq.com/forum/m/260061/67467/#msg_260061
Import from Excel
http://www.orafaq.com/forum/mv/msg/32353/86299/67467/#msg_86299
Forms to Excel example with webutil
http://forums.oracle.com/forums/thread.jspa?messageID=1430799
Another Forms to Excel example
http://www.orafaq.com/forum/t/81537/67467/
How to kill EXCEL.exe from Task Manager from Oracle Forms
http://www.orafaq.com/forum/t/88643/67467/
how do i display all excel worksheets name in form
http://www.orafaq.com/forum/t/89775/67467/
More Excel stuff
http://www.orafaq.com/forum/t/90502/67467/
To run an excel macro
http://www.orafaq.com/forum/t/47685/67467/
Worked example for using Excel through ODBC
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4406709207206#18830681837358

I don't like the idea of concatenting 'excel.exe' to 'excel.exe'.

Are you sure THIS code works in XP?

David
Previous Topic: Problem Installing Forms6i
Next Topic: How to read CLOB values into d2k form.
Goto Forum:
  


Current Time: Wed Dec 07 06:35:44 CST 2016

Total time taken to generate the page: 0.17088 seconds