Home » RDBMS Server » Server Utilities » Field in data file exceeds maximum length (Oracle R12, Windows7)
Field in data file exceeds maximum length [message #600967] |
Thu, 14 November 2013 05:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
adit102
Messages: 9 Registered: November 2010
|
Junior Member |
|
|
Hi,
I am loading data in new instance using CTL file. But getting error as 'Field in data file exceeds maximum length' for few records. Remaining records are getting inserted successfully.
Log file, Control file, Table description etc. here
LOG FILE
========
SQL*Loader: Release 10.1.0.5.0 - Production on Thu Nov 14 04:39:19 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: /tstn2i/applmgr/CUSTOM/xxdm/12.0.0/bin/XXDM_DM_17_AR_RECEIPTS_ONACCT_SRC.ctl
Character Set WE8ISO8859P1 specified for all input.
Data File: /tstn2i/applmgr/CUSTOM/xxdm/12.0.0/inbound/MOD_DM_17/stal_dm17_18_ar_receipts_20131025115722.dat
Bad File: /tstn2i/applmgr/CUSTOM/xxdm/12.0.0/inbound/MOD_DM_17/process/stal_dm17_18_ar_receipts_2013102511572220131114043919.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 2
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", loaded when 1:7 != 0X464f4f5445523d(character 'FOOTER=')
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
COUNT_COL FIRST * | O(") CHARACTER
(FILLER FIELD)
RECEIPT_NUMBER NEXT * | O(") CHARACTER
OPERATING_UNIT NEXT * | O(") CHARACTER
CURRENCY NEXT * | O(") CHARACTER
UNAPPLIED_AMOUNT NEXT * | O(") CHARACTER
CUSTOMER_NAME NEXT * | O(") CHARACTER
POSTMARK_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:POSTMARK_DATE ,'DD-MON-YYYY HH24:MI:SS')"
DEPOSITE_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:DEPOSITE_DATE ,'DD-MON-YYYY HH24:MI:SS')"
GL_DATE_RECEIPT NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:GL_DATE_RECEIPT ,'DD-MON-YYYY HH24:MI:SS')"
RECEIPT_METHOD NEXT * | O(") CHARACTER
REMITTANCE_BANK_ACCOUNT NEXT * | O(") CHARACTER
APPLIED NEXT * | O(") CHARACTER
ACTIVITY NEXT * | O(") CHARACTER
BATCH_REMITTANCE_METHOD NEXT * | O(") CHARACTER
CUSTOMER_BANK_ACCOUNT NEXT * | O(") CHARACTER
CUSTOMER_NUMBER NEXT * | O(") CHARACTER
FUNCTIONAL_AMOUNT NEXT * | O(") CHARACTER
ISSUE_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:ISSUE_DATE ,'DD-MON-YYYY HH24:MI:SS')"
EXCHANGE_RATE_TYPE NEXT * | O(") CHARACTER
EXCHANGE_RATE NEXT * | O(") CHARACTER
EXCHANGE_RATE_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:EXCHANGE_RATE_DATE ,'DD-MON-YYYY HH24:MI:SS')"
ISSUER_BANK_BRANCH NEXT * | O(") CHARACTER
ISSUER_BANK_NAME NEXT * | O(") CHARACTER
ISSUER_NAME NEXT * | O(") CHARACTER
LINE_NUMBER NEXT * | O(") CHARACTER
LOCATION NEXT * | O(") CHARACTER
APPLY_TO NEXT * | O(") CHARACTER
OVERIDE_REMITTANCE_BANK NEXT * | O(") CHARACTER
PAID_FROM NEXT * | O(") CHARACTER
POSTED_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:POSTED_DATE ,'DD-MON-YYYY HH24:MI:SS')"
RECEIPT_BATCH NEXT * | O(") CHARACTER
RECEIPT_CLASS NEXT * | O(") CHARACTER
RECEIPT_CREATION_METHOD NEXT * | O(") CHARACTER
REFERENCE_NUMBER NEXT * | O(") CHARACTER
REFERENCE_TYPE NEXT * | O(") CHARACTER
REMITTANCE_BANK_BRANCH NEXT * | O(") CHARACTER
REMITTANCE_BANK_CURR NEXT * | O(") CHARACTER
REMITTANCE_BANK_NAME NEXT * | O(") CHARACTER
REMITTANCE_BATCH NEXT * | O(") CHARACTER
AMOUNT_APPLIED NEXT * | O(") CHARACTER
TRANS_CURRENCY NEXT * | O(") CHARACTER
GL_DATE_APP NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:GL_DATE_APP ,'DD-MON-YYYY HH24:MI:SS')"
ALLOCATED_RECEIPT_AMOUNT NEXT * | O(") CHARACTER
CROSS_CURRENCY_RATE NEXT * | O(") CHARACTER
EXCHANGE_GAIN_LOSS NEXT * | O(") CHARACTER
APPLICATION_REFERENCE_TYPE NEXT * | O(") CHARACTER
APPLICATION_REFERENCE_NUMBER NEXT * | O(") CHARACTER
APPLICATION_REFERENCE_REASON NEXT * | O(") CHARACTER
LINE_NUMBER1 NEXT * | O(") CHARACTER
CLASS NEXT * | O(") CHARACTER
TYPE NEXT * | O(") CHARACTER
ALLOCATED_RECEIPT_AMOUNT_BASE NEXT * | O(") CHARACTER
AMOUNT_APPLIED_BASE NEXT * | O(") CHARACTER
AMOUNT_DUE_ORIGINAL NEXT * | O(") CHARACTER
BALANCE_DUE_BASE NEXT * | O(") CHARACTER
CUSTOMER_REASON NEXT * | O(") CHARACTER
CUSTOMER_REFERENCE NEXT * | O(") CHARACTER
DATE_POSTED_TO_GL NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:DATE_POSTED_TO_GL ,'DD-MON-YYYY HH24:MI:SS')"
MATURITY_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:MATURITY_DATE ,'DD-MON-YYYY HH24:MI:SS')"
ORIGINAL_TRANSACTION_REFERENCE NEXT * | O(") CHARACTER
ORIGINAL_TRANSACTION_REF_TYPE NEXT * | O(") CHARACTER
PURCHASE_ORDER NEXT * | O(") CHARACTER
TRANS_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:TRANS_DATE ,'DD-MON-YYYY HH24:MI:SS')"
HIST_GL_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:HIST_GL_DATE ,'DD-MON-YYYY HH24:MI:SS')"
HIST_AMOUNT NEXT * | O(") CHARACTER
ACTUAL_VALUE_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:ACTUAL_VALUE_DATE ,'DD-MON-YYYY HH24:MI:SS')"
CASH_RECEIPT_ID NEXT * | O(") CHARACTER
CUSTOMER_ID NEXT * | O(") CHARACTER
CUSTOMER_ACCOUNT_ID NEXT * | O(") CHARACTER
CUST_BANK_ACCOUNT_ID NEXT * | O(") CHARACTER
CUSTOMER_SITE_USE_ID NEXT * | O(") CHARACTER
RECEIPT_METHOD_ID NEXT * | O(") CHARACTER
TRANS_NUMBER NEXT * | O(") CHARACTER
CURRENCY1 NEXT * | O(") CHARACTER
FACTOR_DISCOUNT_AMOUNT NEXT * | O(") CHARACTER
ACCOUNT_NUMBER NEXT * | O(") CHARACTER
INVOICE_CURRENCY_CODE NEXT * | O(") CHARACTER
STATE NEXT * | O(") CHARACTER
RECEIPT_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:RECEIPT_DATE ,'DD-MON-YYYY HH24:MI:SS')"
RECEIPT_AMOUNT NEXT * | O(") CHARACTER
COMMENTS NEXT * | O(") CHARACTER
SQL string for column : "REPLACE(:COMMENTS ,'~' ,' ')"
RECEIPT_TYPE NEXT * | O(") CHARACTER
ON_ACCOUNT NEXT * | O(") CHARACTER
LEGAL_ENTITY NEXT * | O(") CHARACTER
EARNED_DISCOUNT NEXT * | O(") CHARACTER
UNEARNED_DISCOUNT NEXT * | O(") CHARACTER
APPLY_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:APPLY_DATE ,'DD-MON-YYYY HH24:MI:SS')"
DISCOUNT NEXT * | O(") CHARACTER
REVERSAL_GL_DATE NEXT * | O(") CHARACTER
SQL string for column : "TO_DATE(:REVERSAL_GL_DATE ,'DD-MON-YYYY HH24:MI:SS')"
DAYS_LATE NEXT * | O(") CHARACTER
TYPE1 NEXT * | O(") CHARACTER
value used for ROWS parameter changed from 64 to 11
Record 262: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 263: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 368: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 369: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 370: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 371: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 372: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 373: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 459: Rejected - Error on table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC", column COMMENTS.
Field in data file exceeds maximum length
Record 520: Discarded - failed all WHEN clauses.
Table "XXDM"."XXDM_DM_17_ONACCOUNT_REC_SRC":
510 Rows successfully loaded.
9 Rows not loaded due to data errors.
1 Row not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 255420 bytes(11 rows)
Read buffer bytes: 1048576
Total logical records skipped: 2
Total logical records read: 520
Total logical records rejected: 9
Total logical records discarded: 1
Run began on Thu Nov 14 04:39:19 2013
Run ended on Thu Nov 14 04:39:22 2013
Elapsed time was: 00:00:03.10
CPU time was: 00:00:00.05
CTL FILE
========
OPTIONS (SKIP=2)
LOAD DATA
CHARACTERSET WE8ISO8859P1
INFILE '$FILE'
APPEND
INTO TABLE "XXDM_DM_17_ONACCOUNT_REC_SRC"
WHEN (1)!= 'FOOTER='
FIELDS TERMINATED BY '|'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
COUNT_COL FILLER,
RECEIPT_NUMBER,
OPERATING_UNIT,
CURRENCY,
UNAPPLIED_AMOUNT,
CUSTOMER_NAME,
POSTMARK_DATE "TO_DATE(:POSTMARK_DATE ,'DD-MON-YYYY HH24:MI:SS')",
DEPOSITE_DATE "TO_DATE(:DEPOSITE_DATE ,'DD-MON-YYYY HH24:MI:SS')",
GL_DATE_RECEIPT "TO_DATE(:GL_DATE_RECEIPT ,'DD-MON-YYYY HH24:MI:SS')",
RECEIPT_METHOD,
REMITTANCE_BANK_ACCOUNT,
APPLIED,
ACTIVITY,
BATCH_REMITTANCE_METHOD,
CUSTOMER_BANK_ACCOUNT,
CUSTOMER_NUMBER,
FUNCTIONAL_AMOUNT,
ISSUE_DATE "TO_DATE(:ISSUE_DATE ,'DD-MON-YYYY HH24:MI:SS')",
EXCHANGE_RATE_TYPE,
EXCHANGE_RATE,
EXCHANGE_RATE_DATE "TO_DATE(:EXCHANGE_RATE_DATE ,'DD-MON-YYYY HH24:MI:SS')",
ISSUER_BANK_BRANCH,
ISSUER_BANK_NAME,
ISSUER_NAME,
LINE_NUMBER,
LOCATION,
APPLY_TO,
OVERIDE_REMITTANCE_BANK,
PAID_FROM,
POSTED_DATE "TO_DATE(:POSTED_DATE ,'DD-MON-YYYY HH24:MI:SS')",
RECEIPT_BATCH,
RECEIPT_CLASS,
RECEIPT_CREATION_METHOD,
REFERENCE_NUMBER,
REFERENCE_TYPE,
REMITTANCE_BANK_BRANCH,
REMITTANCE_BANK_CURR,
REMITTANCE_BANK_NAME,
REMITTANCE_BATCH,
AMOUNT_APPLIED,
TRANS_CURRENCY,
GL_DATE_APP "TO_DATE(:GL_DATE_APP ,'DD-MON-YYYY HH24:MI:SS')",
ALLOCATED_RECEIPT_AMOUNT,
CROSS_CURRENCY_RATE,
EXCHANGE_GAIN_LOSS,
APPLICATION_REFERENCE_TYPE,
APPLICATION_REFERENCE_NUMBER,
APPLICATION_REFERENCE_REASON,
LINE_NUMBER1,
CLASS,
TYPE,
ALLOCATED_RECEIPT_AMOUNT_BASE,
AMOUNT_APPLIED_BASE,
AMOUNT_DUE_ORIGINAL,
BALANCE_DUE_BASE,
CUSTOMER_REASON,
CUSTOMER_REFERENCE,
DATE_POSTED_TO_GL "TO_DATE(:DATE_POSTED_TO_GL ,'DD-MON-YYYY HH24:MI:SS')",
MATURITY_DATE "TO_DATE(:MATURITY_DATE ,'DD-MON-YYYY HH24:MI:SS')",
ORIGINAL_TRANSACTION_REFERENCE,
ORIGINAL_TRANSACTION_REF_TYPE,
PURCHASE_ORDER,
TRANS_DATE "TO_DATE(:TRANS_DATE ,'DD-MON-YYYY HH24:MI:SS')",
HIST_GL_DATE "TO_DATE(:HIST_GL_DATE ,'DD-MON-YYYY HH24:MI:SS')",
HIST_AMOUNT,
ACTUAL_VALUE_DATE "TO_DATE(:ACTUAL_VALUE_DATE ,'DD-MON-YYYY HH24:MI:SS')",
CASH_RECEIPT_ID,
CUSTOMER_ID,
CUSTOMER_ACCOUNT_ID,
CUST_BANK_ACCOUNT_ID,
CUSTOMER_SITE_USE_ID,
RECEIPT_METHOD_ID,
TRANS_NUMBER,
CURRENCY1,
FACTOR_DISCOUNT_AMOUNT,
ACCOUNT_NUMBER,
INVOICE_CURRENCY_CODE,
STATE,
RECEIPT_DATE "TO_DATE(:RECEIPT_DATE ,'DD-MON-YYYY HH24:MI:SS')",
RECEIPT_AMOUNT,
COMMENTS "REPLACE(:COMMENTS ,'~' ,' ')",
RECEIPT_TYPE,
ON_ACCOUNT,
LEGAL_ENTITY,
EARNED_DISCOUNT,
UNEARNED_DISCOUNT,
APPLY_DATE "TO_DATE(:APPLY_DATE ,'DD-MON-YYYY HH24:MI:SS')",
DISCOUNT,
REVERSAL_GL_DATE "TO_DATE(:REVERSAL_GL_DATE ,'DD-MON-YYYY HH24:MI:SS')",
DAYS_LATE,
TYPE1
)
TABLE DESCRIPTION
=================
COLUMN NAME DATATYPE
----------- --------
RECEIPT_NUMBER VARCHAR2 (30 Byte)
OPERATING_UNIT VARCHAR2 (100 Byte)
CURRENCY VARCHAR2 (10 Byte)
UNAPPLIED_AMOUNT NUMBER
CUSTOMER_NAME VARCHAR2 (100 Byte)
POSTMARK_DATE DATE
DEPOSITE_DATE DATE
GL_DATE_RECEIPT DATE
RECEIPT_METHOD VARCHAR2 (30 Byte)
REMITTANCE_BANK_ACCOUNT NUMBER
APPLIED NUMBER
ACTIVITY VARCHAR2 (30 Byte)
BATCH_REMITTANCE_METHOD VARCHAR2 (30 Byte)
CUSTOMER_BANK_ACCOUNT NUMBER
CUSTOMER_NUMBER VARCHAR2 (30 Byte)
FUNCTIONAL_AMOUNT NUMBER
ISSUE_DATE DATE
EXCHANGE_RATE_TYPE VARCHAR2 (30 Byte)
EXCHANGE_RATE NUMBER
EXCHANGE_RATE_DATE DATE
ISSUER_BANK_BRANCH VARCHAR2 (100 Byte)
ISSUER_BANK_NAME VARCHAR2 (100 Byte)
ISSUER_NAME VARCHAR2 (100 Byte)
LINE_NUMBER NUMBER
LOCATION VARCHAR2 (100 Byte)
APPLY_TO VARCHAR2 (100 Byte)
OVERIDE_REMITTANCE_BANK VARCHAR2 (100 Byte)
PAID_FROM VARCHAR2 (100 Byte)
POSTED_DATE DATE
RECEIPT_BATCH VARCHAR2 (30 Byte)
RECEIPT_CLASS VARCHAR2 (30 Byte)
RECEIPT_CREATION_METHOD VARCHAR2 (30 Byte)
REFERENCE_NUMBER VARCHAR2 (30 Byte)
REFERENCE_TYPE VARCHAR2 (30 Byte)
REMITTANCE_BANK_BRANCH VARCHAR2 (100 Byte)
REMITTANCE_BANK_CURR VARCHAR2 (10 Byte)
REMITTANCE_BANK_NAME VARCHAR2 (100 Byte)
REMITTANCE_BATCH VARCHAR2 (30 Byte)
AMOUNT_APPLIED NUMBER
TRANS_CURRENCY VARCHAR2 (10 Byte)
GL_DATE_APP DATE
ALLOCATED_RECEIPT_AMOUNT NUMBER
CROSS_CURRENCY_RATE NUMBER
EXCHANGE_GAIN_LOSS NUMBER
APPLICATION_REFERENCE_TYPE VARCHAR2 (30 Byte)
APPLICATION_REFERENCE_NUMBER VARCHAR2 (30 Byte)
APPLICATION_REFERENCE_REASON VARCHAR2 (30 Byte)
LINE_NUMBER1 NUMBER
CLASS VARCHAR2 (30 Byte)
TYPE VARCHAR2 (30 Byte)
ALLOCATED_RECEIPT_AMOUNT_BASE NUMBER
AMOUNT_APPLIED_BASE NUMBER
AMOUNT_DUE_ORIGINAL NUMBER
BALANCE_DUE_BASE NUMBER
CUSTOMER_REASON VARCHAR2 (50 Byte)
CUSTOMER_REFERENCE VARCHAR2 (50 Byte)
DATE_POSTED_TO_GL DATE
MATURITY_DATE DATE
ORIGINAL_TRANSACTION_REFERENCE VARCHAR2 (50 Byte)
ORIGINAL_TRANSACTION_REF_TYPE VARCHAR2 (50 Byte)
PURCHASE_ORDER VARCHAR2 (50 Byte)
TRANS_DATE DATE
HIST_GL_DATE DATE
HIST_AMOUNT NUMBER
ACTUAL_VALUE_DATE DATE
CASH_RECEIPT_ID NUMBER
CUSTOMER_ID NUMBER
CUSTOMER_ACCOUNT_ID NUMBER
CUST_BANK_ACCOUNT_ID NUMBER
CUSTOMER_SITE_USE_ID NUMBER
RECEIPT_METHOD_ID NUMBER
TRANS_NUMBER NUMBER
CURRENCY1 VARCHAR2 (10 Byte)
FACTOR_DISCOUNT_AMOUNT NUMBER
ACCOUNT_NUMBER VARCHAR2 (50 Byte)
INVOICE_CURRENCY_CODE VARCHAR2 (10 Byte)
STATE VARCHAR2 (50 Byte)
RECEIPT_DATE DATE
RECEIPT_AMOUNT NUMBER
COMMENTS VARCHAR2 (2000 Byte)
RECEIPT_TYPE VARCHAR2 (30 Byte)
ON_ACCOUNT NUMBER
LEGAL_ENTITY VARCHAR2 (100 Byte)
EARNED_DISCOUNT NUMBER
UNEARNED_DISCOUNT NUMBER
APPLY_DATE DATE
DISCOUNT NUMBER
REVERSAL_GL_DATE DATE
DAYS_LATE NUMBER
TYPE1 VARCHAR2 (30 Byte)
ORG_ID NUMBER
ATTRIBUTE_REC VARCHAR2 (30 Byte)
GLOBAL_ATTRIBUTE_REC VARCHAR2 (30 Byte)
SECONDARY_APPLICATION_REF VARCHAR2 (30 Byte)
CALLED_FROM VARCHAR2 (30 Byte)
USR_CURRENCY_CODE VARCHAR2 (10 Byte)
USR_EXCHANGE_RATE_TYPE VARCHAR2 (10 Byte)
CUSTOMER_BANK_ACCOUNT_NUM VARCHAR2 (30 Byte)
CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (100 Byte)
PAYMENT_TRXN_EXTENSION_ID NUMBER
DEFAULT_SITE_USE VARCHAR2 (30 Byte)
CUSTOMER_RECEIPT_REFERENCE VARCHAR2 (30 Byte)
REMITTANCE_BANK_ACCOUNT_ID NUMBER
REMITTANCE_BANK_ACCOUNT_NAME VARCHAR2 (10 Byte)
DOC_SEQUENCE_VALUE VARCHAR2 (30 Byte)
ANTICIPATED_CLEARING_DATE DATE
INSTALLMENT VARCHAR2 (30 Byte)
SAMPLE DATA
===========
368|ABCD-130128-10|New Org OU|GBP|29.59|ABC Telecom Plc||28-JAN-2013 00:00:00|28-JAN-2013 00:00:00|ABC BACS|31310484|3293.31||1169||333163|3322.9||||28-JAN-2013 00:00:00|||||333163/4|300001554|N|3352|01-FEB-2013 00:00:00|10548|ABC BACS|Manual|||ABC CORP SUPPORT CENTRE - 160400|GBP|The Royal Bank of ABC|1169|1290|GBP|01-JUN-2013 00:00:00|1290||0|||||Payment|Property|1290|1290|-3322.9|-29.59|||21-JUN-2013 00:00:00|28-JAN-13||||28-JAN-2013 00:00:00|28-JAN-2013 00:00:00|3322.9|28-JAN-2013 00:00:00|57531|3352|3352|3110|5940|2006||GBP|0|333163|GBP|CLEARED|28-JAN-2013 00:00:00|3322.9|Hi Rebecca~I have just spoken to our finance department and they have agreed that the ABCs payments made can be allocated to the overdue invoices, can you send any future invoices direct to me so that I can get them paid on time.~Hope this is ok ~Thanks~Terry~|CASH||ABC Org Ltd|0|0|01-JUL-2013 00:00:00|0||0|Property|
ERROR DATA FROM ABOVE SAMPLE
============================
Hi Rebecca~I have just spoken to our finance department and they have agreed that the ABCs payments made can be allocated to the overdue invoices, can you send any future invoices direct to me so that I can get them paid on time.~Hope this is ok ~Thanks~Terry~
Is this error because of the special characters used?
Please let me know what changes do I need to make.
Thanks,
Aditya
[EDITED by LF: applied [spoiler] tags to shorten a lengthy message]
[Updated on: Thu, 14 November 2013 14:11] by Moderator Report message to a moderator
|
|
|
|
Re: Field in data file exceeds maximum length [message #601019 is a reply to message #600967] |
Thu, 14 November 2013 12:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/43710.gif) |
Barbara Boehmer
Messages: 9104 Registered: November 2002 Location: California, USA
|
Senior Member |
|
|
If you do not specify a length for your field in your control file, then it uses the default value of 255. So, if your comments are longer than 255, then you get the error. Since your comments column in your table has a length of 2000, instead of:
COMMENTS "REPLACE(:COMMENTS ,'~' ,' ')",
you should use:
COMMENTS CHAR(2000) "REPLACE(:COMMENTS ,'~' ,' ')",
|
|
|
Goto Forum:
Current Time: Thu Feb 06 21:43:48 CST 2025
|