TOracleDirectPathLoader

[moinelli]

I have the latest version of DAO and am
using it with Oracle 8.16. I started using
the loader module which work fine with my test file (which had only two fields). When I went to use one of my production files (41 fields all string - 241 characters total), During the loader.prepare method I get the error ORA-2373 error parsing inset and ORA-01747 invalid table, column name ect. Is there a limit to the number of fields for the loader?

------------------
Bob

 

[Marco Kalter]

Im not aware of any limitations. Can you send me a table definition, import file, and demo project? If this is too much work, just send me the table definition.

------------------
Marco Kalter
Allround Automations

 

[moinelli]

Originally posted by mkalter:
Im not aware of any limitations. Can you send me a table definition, import file, and demo project? If this is too much work, just send me the table definition.

Below is the file description, I am not loading it from a text file but building it
from a dbf file. Again, other files work OK, not sure why this file the aborts when the 'prepare' is executed. Looking at the file desc two fields stand out 'date' and 'arc'.
Connected to Oracle8i Enterprise Edition Release 8.1.6.0.0
Connected as fin

SQL> desc f09hist
Name Type Nullable Default Comments
---------- ------------ -------- ------- --------
DIC VARCHAR2(3) Y
RIC_SOS VARCHAR2(3) Y
F1 VARCHAR2(1) Y
FSN VARCHAR2(15) Y
UI VARCHAR2(2) Y
QTY VARCHAR2(5) Y
DODAAC VARCHAR2(6) Y
DATE VARCHAR2(4) Y
SERIAL VARCHAR2(4) Y
SUFFIX_CD VARCHAR2(1) Y
SUPP_ADDR VARCHAR2(6) Y
SIG_CODE VARCHAR2(1) Y
FC VARCHAR2(2) Y
DIST_CODE VARCHAR2(3) Y
PROJ_CD VARCHAR2(3) Y
PRIORITY VARCHAR2(2) Y
TRANS_DATE VARCHAR2(3) Y
ST_CODE VARCHAR2(2) Y
RIC VARCHAR2(3) Y
SHIP_DATE VARCHAR2(4) Y
U_PRICE VARCHAR2(7) Y
RIC_FRM VARCHAR2(3) Y
RIC_TO VARCHAR2(3) Y
TRAN_DATE VARCHAR2(5) Y
ARC VARCHAR2(1) Y
MATCAT VARCHAR2(2) Y
NOMENCLAT VARCHAR2(21) Y
SOS_RIC VARCHAR2(3) Y
SC VARCHAR2(1) Y
SUB_SC VARCHAR2(1) Y
U_I VARCHAR2(2) Y
U_P VARCHAR2(9) Y
ARI VARCHAR2(1) Y
MRC VARCHAR2(1) Y
PR_SIG_CD VARCHAR2(1) Y
FILLER VARCHAR2(15) Y
ERRCODE VARCHAR2(1) Y
DOC VARCHAR2(14) Y
F09SOURCE VARCHAR2(3) Y
TAPENUM VARCHAR2(3) Y
BAD_DODAAC VARCHAR2(1) Y

SQL>

 

[Marco Kalter]

How can you create a table with a column named 'DATE'? This is a reserved word?

------------------
Marco Kalter
Allround Automations

 

[moinelli]

I created using the Delphi BDE. I am
in the process or porting some old application's in Clipper to Oracle. Looks
the file structure will have to change.

Originally posted by mkalter:
How can you create a table with a column named 'DATE'? This is a reserved word?