Excel data load for Banco Oracle

[marlonpasquali]

Good morning,
staff, I have a system developed in Forms 6i, and in which I would like to be able to read an Excel spreadsheet and do insert at the Oracle 10g Bank.
Does anyone know any routine that can read an Excel spreadsheet and insert your data into an Oracle bank?

Thanks
Marlon

[marlonpasquali]

Personal,
I was able to load the data using DDE.Request
but the routine can read only 100 lines of the worksheet and gives the error or-106552
so I searched is an error timeout that closes the worksheet.
Someone already passed this problem? Can I help me?

Thanks
Marlon

Select all

dde.request(docid 
              ,replace(vs_posicao,' ') 
              ,v_ds_dado 
              ,dde.cf_text 
              ,10000);

[Renato Menezes Viana]

Marlon, has already tried the topic below:
http://en.glufke.net/oracle/viewtopic.php?f=4&t=6386
ABS, Renato Viana

[stcoutinho]

Hi Marlon

I do not know the package, but I searched a little on the theme .. and it seems to me that it would be necessary to increase the timeout parameter in DDE.Execute. And maybe do a treatment for the exception of DDE.DMLERR_DATACACKTIMEOUT.

Metalink seems to have an explanatory note (Resolving FRM-40735 Errors [Doc ID 61579.1]).

Hugs,

Sergio

[marlonpasquali]

Thank you Sergio,
I also found the same document and increased the timeout.
The routine is now working.
Thank you all for the tips.

ATT,
Marlon