|
[x]
Posted via EE Mobile
|
|
| Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
|
|
|
|
Asked by Syedhamid in PL / SQL, Oracle Database
Hi,
I am trying to upload the CSV file through external table, some strange problem i am facing here, I am able to uplaod the complete data if my file is having 124 records, if I am adding one more records in CSV file, external table is not populating any data. below are my code and attached is my file (please look for last record, if i am adding this records external table is not populating any data, if i remove the last row then its working fine).
Please help me to resolve this issue ASAP
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
|
EXECUTE IMMEDIATE ('
create table t24_ext_receipt
(
agreementid Number,
agreementno Varchar2(20),
accountno Varchar2(20),
duedate date,
receivedamt number(16,2)
)
organization external
(
type oracle_loader
default directory T24_INTERFACE
access parameters
(
records delimited by newline
logfile T24_INTERFACE:''xtern_empl_rpt.log''
badfile T24_INTERFACE:''xtern_empl_rpt.bad''
NODISCARDFILE
fields terminated by '',''
missing field values are null
)
location (''' || i.file_name || ''')
)
parallel
reject limit 10000 ');
|
20091021-EE-VQP-81 - Hierarchy / EE_QW_3_20080625
