Re: SQL Loader question

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