Re: SQL*Loader Syntax Problem

Hi,

Thanks for the solution... it works now, but....

How can I "avoid" inserting the recid value into the tables? I really just want to use the recid value to tell what table to insert the data into.

Thanks in advance,

Stephen Earl...

Frido van Orden wrote in message <6vd210$hs6$1_at_news.worldonline.nl>...
>Made this fault myself as well. In the 'WHEN' clauses you need to specify a
>character string (as the error message indicates), so use
>
>WHEN recid = '1'
>
>instead. This is because the when clause is applied to the data as read
from
>the file, not the converted data (e.g. unpacking or converting to integers)
>
>Hope this helps,
>Frido
>
>Stephen Earl wrote in message ...
>>Hello All,
>>
>>I'm trying to load two tables from a single
>>delimited control file and I'm getting the
>>following error:
>>
>>SQL*Loader-350: Syntax error at line 8.
>>Expecting quoted string or hex identifier, found
>>"1".
>>WHEN recid = 1
>>^
>>
>
>
>
>
Received on Tue Oct 06 1998 - 08:28:36 CDT