no terminator found after TERMINATED and ENCLOSED field [message #74012] |
Tue, 24 August 2004 00:13 |
Raju
Messages: 74 Registered: March 1999
|
Member |
|
|
Hi,
I'm getting following error while trying to load data through SQL*Loader.
"Record 18: Rejected - Error on table "OSD1"."STEP_POOL_TMPLS", column ID. no terminator found after TERMINATED and ENCLOSED field"
Any idea whats wrong with my CTL file.
INTO TABLE STEP_POOL_TMPLS
WHEN (1:15) = 'Step_Pool_Tmpls'
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
( ID "SPT_SEQ.NEXTVAL", VN POSITION(17), CALL_SEQ_TMPL_ID, CALL_SEQ_TMPL_VN, STEP_POOL CHAR(10485760))
BEGINDATA
Step_Pool_Tmpls,0,37509,0,"StepPoolVn=4,^MStepPool={ SCSStep=(^M ID=""##"",^M Nm=""RUL
SubCallSequence"",^M Vn=""0"",^M Sts=""READY_TO_RUN"",^M Desc=""To provide the cancellati
on reason and cacellation date time (PR71)"",^M SeqNo=""10"",^M SCSName=""BB Set FM Parameters On Immedi
ate Cancellation"",^M SCSID=""41090"",^M NoRet=""N"",^M EndCallSeq=""N"",^M
Inputs={},^M Outputs={},^M ErrorMap={}^M )
,^M ^M}",
Its working fine when I use ID COLUMN (MAX,1) instead ID "spt_seq.nextval". Since my application is multi user system I want to make sure that same ID is not generated for different users. I'm not sure whether it is something to do with complex string which I'm trying to insert into step_pool column. But the Error which I'm getting on ID column.
Step_POOL_TMPLS table structure...
Name Null? Type
----------------------------------------- -------- ----
ID NOT NULL NUMBER(10)
VN NOT NULL NUMBER(6)
CALL_SEQ_TMPL_ID NOT NULL NUMBER(10)
CALL_SEQ_TMPL_VN NOT NULL NUMBER(6)
STEP_POOL NOT NULL LONG
Any help would be highly appreciated.
Thanks in advance
Raju
|
|
|