Xref: alice comp.databases.oracle.tools:21951
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!solomon.io.com!news-feeds.jump.net!nntp2.dejanews.com!nnrp1.dejanews.com!not-for-mail
From: HowardParks@my-dejanews.com
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL Loader question
Date: Wed, 03 Mar 1999 14:44:39 GMT
Organization: Deja News - The Leader in Internet Discussion
Lines: 27
Message-ID: <7bjhsk$3sb$1@nnrp1.dejanews.com>
References: <36DB0453.224E7B41@erols.com> <36dc297b$0$24066@newton>
X-Article-Creation-Date: Wed Mar 03 14:44:39 1999 GMT
X-Http-User-Agent: Mozilla/4.5 [en] (WinNT; I)
X-Http-Proxy: 1.0 x15.dejanews.com:80 (Squid/1.1.22) for client 207.250.55.254

In article <36dc297b$0$24066@newton>,
  "Arjan van Bentem" <avbentem@DONT-YOU-DAREdds.nl> wrote:
> 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?
<SNIP>

I was very surprised to read that this is a legal name in Oracle.
Ya learn something new every day...

You need the quotes around the field name, but preceded by an escape
character. Try:

"EST-LABOR-COST-01" POSITION (209:217) DECIMAL EXTERNAL
   ":\"EST-LABOR-COST-01\"/100"


Howard Parks
1 Peter 4:10

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own