Re: SQL*Loader Syntax Problem

From: Frido van Orden <fridoo_at_faapartners.com>
Date: Tue, 6 Oct 1998 14:18:30 +0200
Message-ID: <6vd210$hs6$1@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 - 07:18:30 CDT