Database Software

Dear all,

I have created a external table to load a simple csv file to the database. On executing a select statement on the external table I'm getting the following errors:

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "minussign": expecting one of: "column, ("
KUP-01007: at line 5 column 10


I checked several other threads but nothing helped. Does somebody have any idea what the problem is?

Here my code:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production


-- User OLI
create directory dir_ims2eip_procdata as '/home/host/ifc/ims2eip/procdata';

grant read, write on directory dir_ims2eip_procdata to stammdaten;


-- User STAMMDATEN

CREATE TABLE mitarbeiter_imp_ext
( nummer1 varchar2(100)
,active2 varchar2(100)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY DIR_IMS2EIP_PROCDATA
ACCESS PARAMETERS
(
records delimited by newline
fields terminated by ';'
MISSING FIELD VALUES ARE NULL
REJECT ROWS WITH ALL NULL FIELDS
)
LOCATION ('lms2eip_mitarbeiter.csv')
) ;


Part of my csv file:

2;Y
3;N
4;Y



That's it.


Any suggestions?

Thanks a lot!

Best regards
Oli