Hi All,
Iam getting following warning
IDEXECLOADTBLE..fmtrec: The value of the row is: IDEXEC_ID = 221620 CONTACT_FULL_NM = MR. ROB ROUTSON CONTACT_TITLE = VICE PRESIDENT-RISK MANAGEMENT COMPANY_NM = DIGITAL FEDERAL CREDIT UNION LOC_ADDRESS_LINE1 = 220 DONALD LYNCH BOULEVARD LOC_ADDRESS_LINE2 = MARLBOROUGH, MA 01752 LOC_ADDRESS_LINE3 = NULL LOC_COUNTRY_CD = 920 LOC_STATE = MA LOC_STATE_CD = MA LOC_POSTAL_CODE = 01752 LOC_ZIP_CD = 01752 LOC_ZIP_EXT_CD = NULL MAIL_ADDRESS_LINE1 = P O BOX 9130 MAIL_ADDRESS_LINE2 = MARLBOROUGH, MA 01752-9130 MAIL_ADDRESS_LINE3 =
DBMS.CODE=ORA-01438
I donot understand which field is crossing the length limit, how to identify
the field and IDEXEC_ID is a sequence number and defined as numeric
in the table and when imported it is as decimal type in datastage , is that
causing this warning...
Any ideas , any inputs greatly appreaciated.
warning!! in OCI stage
Moderators: chulett, rschirm, roy
This is what i found by doing a google on the dbms code
ORA-01438: value larger than specified precision allows for this column
Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.
Action: Enter a value that complies with the numeric column's precision, or use the MODIFY option with the ALTER TABLE command to expand the precision.
I think that might be the reason. The decimal defined column.
ORA-01438: value larger than specified precision allows for this column
Cause: When inserting or updating records, a numeric value was entered that exceeded the precision defined for the column.
Action: Enter a value that complies with the numeric column's precision, or use the MODIFY option with the ALTER TABLE command to expand the precision.
I think that might be the reason. The decimal defined column.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm