Database Software

Hello,
I am using a oracle external table to query a flat file. I have saved the file as "unicode". When I execute the script, the select returns no rows. Howver the file should be able toppulate around 200,000 rows. If I do not save the file as unicode, the script runs fine and all 200,000 rows are slected. Please help.
The script is

drop table ext_table_fdw ;

create table ext_table_fdw (
Locator_Id NUMBER
, Address_Ln_1_Txt VARCHAR(3000)
,Address_Ln_2_Txt VARCHAR(3000)
,Address_Ln_3_Txt VARCHAR(3000)
,Carrier_Route_Txt VARCHAR(3000)
,Country_Id INTEGER
,Postal_Cd_Id INTEGER
,Priority INTEGER
,Ticket_Group INTEGER
,Ticket_Seq_No INTEGER
,FROM_Date TIMESTAMP
,Till_Date TIMESTAMP
, Process_id INTEGER
)
organization external (
type oracle_loader
default directory ftp_in
access parameters (
records delimited by newline CHARACTERSET AL32UTF8
nologfile
fields terminated by '|'
missing field values are null
(
"LOCATOR_ID"
, "ADDRESS_LN_1_TXT"
,"ADDRESS_LN_2_TXT"
,"ADDRESS_LN_3_TXT"
,"CARRIER_ROUTE_TXT"
,"COUNTRY_ID"
,"POSTAL_CD_ID"
,"PRIORITY"
,"TICKET_GROUP"
,"TICKET_SEQ_NO"
,"FROM_DATE" Char Date_Format Timestamp Mask 'YYYY-MM-DD HH24:Mi:SS:FF6'
,"TILL_DATE" Char Date_Format Timestamp Mask 'YYYY-MM-DD HH24:Mi:SS:FF6'
,"PROCESS_ID"


)
)
location ('new_unicode.txt')
)
reject limit unlimited;


select * from ext_table_fdw


Thanks a lot.
Bst regards,
brinda