Oracle Database Discussions

Creating external table using below syntax

create table bill1
(compname varchar2(50),
account varchar2(100),
filename varchar2(100),
thedate date,
billablelc number(5),
flag varchar2(10),
STPIFLAG char(1))
ORGANIZATION EXTERNAL
(type oracle_loader
default directory dirtemp
ACCESS PARAMETERS
(
RECORDS delimited BY newline
FIELDS terminated BY ','
missing field values are null
(
compname,
account,
filename,
thedate date 'mm/dd/yyyy' ,
billablelc,
flag,
STPIFLAG
)
)
location('bill1.txt')
)


Bill1.txt contains
a74@rediffmail.com,Be Hoal,613443,2006-04-01 00:00:00,26,Supplier,Y
b2003@hotmail.com,Bet Memol,613445,2006-04-01 00:00:00,25,Supplier,Y

Querying the above table the following log is generated.

Error Log
KUP-04021: field formatting error for field THEDATE
KUP-04026: field too long for datatype

Can somebody please comment

Thanks
Kaushik