Re: SQL Loader question
Date: Tue, 2 Mar 1999 19:09:56 +0100
Message-ID: <36dc297b$0$24066_at_newton>
Scott Mattes wrote
>Here is the line where I get the error
> "EST-LABOR-COST-01" POSITION (209:217)
> Decimal External ":EST-LABOR-COST-01 / 100"
It seems to me you have dashes in the column names? Did I miss something, or are dashes simply not allowed in a column name? How should Oracle know the difference between a dash in the column name and a minus sign? If dashes are allowed, then you need to add some quotes in the second line as well. Don't ask me how, though.... Maybe something like:
Decimal External ":""EST-LABOR-COST-01"" / 100"
Decimal External " "":EST-LABOR-COST-01"" / 100"
Decimal External " :'EST-LABOR-COST-01' / 100"
I'd simply prefer never to use dashes, spaces or other characters that might have a different meaning in a programming language.
Arjan. Received on Tue Mar 02 1999 - 19:09:56 CET