Home » RDBMS Server » Server Utilities » SQLLDR Issue with NUMBER data type
SQLLDR Issue with NUMBER data type [message #614324] Tue, 20 May 2014 20:28 Go to previous message
aimy
Messages: 225
Registered: June 2006
Senior Member
Hi all.

I'm really stuck with this basic issue.

My table:
CREATE TABLE S13018_SQLLDR_DATA (
  CATEGORY    CHAR(3)      NULL,
  REGION      VARCHAR2(36) NULL,
  STATE       VARCHAR2(36) NULL,
  DISTRICT    VARCHAR2(36) NULL,
  ZONE_NAME   VARCHAR2(36) NULL,
  BUILDING_ID VARCHAR2(36) NULL,
  TOTAL_COUNT NUMBER(6,0)  NULL
)
/


The data
TEL|EASTERN REGION|PAHANG|PH|ZONE TERUNTUM|AAR|5206
TEL|SOUTHERN REGION|JOHOR|JS|ZONE SKUDAI / PONTIAN|AB|395
TEL|SOUTHERN REGION|JOHOR|JS|ZONE SENAI|ABN|229
TEL|SOUTHERN REGION|MELAKA|MK|ZONE MELAKA UTARA|ABU|635
TEL|SOUTHERN REGION|MELAKA|MK|ZONE MELAKA UTARA|AG|2986
TEL|SOUTHERN REGION|JOHOR|JU|ZONE KLUANG/MERSING|AH|1016


My control file is
load data
  append
  into table s13018_SQLLDR_DATA
  fields terminated by "|"
  trailing nullcols
  (
      CATEGORY       CHAR(3),
      REGION         CHAR(36),
      STATE          CHAR(36),
      DISTRICT       CHAR(36),
      ZONE_NAME      CHAR(36),
      BUILDING_ID    CHAR(36),
      TOTAL_COUNT   INTEGER EXTERNAL
  )


But when I execute the loading, all records were rejected with error:
[/code]Record 1: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number

Record 2: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number

Record 3: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number

Record 4: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number

Record 5: Rejected - Error on table S13018_SQLLDR_DATA, column TOTAL_COUNT.
ORA-01722: invalid number[/code]

Thank you.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Issue in export
Next Topic: Export/Import Criteria
Goto Forum:
  


Current Time: Fri Mar 29 03:49:15 CDT 2024