Re: sqlldr problem
From: Nick Taylor <ntwysiwyg_at_dataskill.co.uk>
Date: Fri, 31 Aug 2001 15:21:04 GMT
Message-ID: <3B8FAB68.8C4EF004_at_dataskill.co.uk>
Date: Fri, 31 Aug 2001 15:21:04 GMT
Message-ID: <3B8FAB68.8C4EF004_at_dataskill.co.uk>
Nick Taylor wrote:
>
And answered himself!!!
>
> My solution was to specify the postcode as:
>
> postcode POSITION(01:07) CHAR
> "RTRIM(SUBSTR(postcode,1,4)) || SUBSTR(postcode,5,7)",
>
On casting my eye over the docs one more time I spotted that the above
should read:
postcode POSITION(01:07) CHAR
"RTRIM(SUBSTR(:postcode,1,4)) || SUBSTR(:postcode,5,7)",
And that's what the mightly Oracle was trying to tell me :-)
Nick
-- Nick Taylor Say No to Spammers - What You See Isn't What You Get to Email MeReceived on Fri Aug 31 2001 - 17:21:04 CEST