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
Excel data load for Banco Oracle
-
- Rank: DBA Pleno
- Posts: 248
- Joined: Fri, 06 Feb 2009 3:02 pm
- Location: ERECHIM - RS
-
- Rank: DBA Pleno
- Posts: 248
- Joined: Fri, 06 Feb 2009 3:02 pm
- Location: ERECHIM - RS
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
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
dde.request(docid
,replace(vs_posicao,' ')
,v_ds_dado
,dde.cf_text
,10000);
-
- Rank: Analista Pleno
- Posts: 128
- Joined: Sat, 18 Nov 2006 11:51 am
- Location: Rio de Janeiro - RJ
Marlon, has already tried the topic below:
http://en.glufke.net/oracle/viewtopic.php?f=4&t=6386
ABS, Renato Viana
http://en.glufke.net/oracle/viewtopic.php?f=4&t=6386
ABS, Renato Viana
- stcoutinho
- Moderador
- Posts: 850
- Joined: Wed, 11 May 2011 5:15 pm
- Location: são Paulo - SP
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
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
-
- Rank: DBA Pleno
- Posts: 248
- Joined: Fri, 06 Feb 2009 3:02 pm
- Location: ERECHIM - RS
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
I also found the same document and increased the timeout.
The routine is now working.
Thank you all for the tips.
ATT,
Marlon
-
- Information
-
Who is online
Users browsing this forum: Google [Bot] and 14 guests