Page 1 of 1

Sever Job: Not able to read (') in data

Posted: Tue Nov 18, 2008 3:56 am
by harshada
Hi,

I have a server job

Seq file read -> transformer-> o/p seq file.


Data contains ... "HE GARDENER'S COTTAGE"

Server job aborts saying


STG_INP_01.INP_01: nls_read_delimited() - invalid quotes, column ADDRESS2 = "HE GARDENER'S COTTAGE","


Is this to be specially handelled?


Thanks

Posted: Tue Nov 18, 2008 8:34 am
by chulett
So do you have a single or double quote inside your quoted string? Guessing the latter even though your example shows the former.