Re: SQL Loader question

From: Scott Mattes <smattes_at_erols.com>
Date: Mon, 01 Mar 1999 16:19:15 -0500
Message-ID: <36DB0453.224E7B41_at_erols.com>



Howard,
  Thank you for the pointer, but either I am doing something wrong or [Quoted] that doesn't work under Oracle 8. Here is the line where I get the error (and the line before/after it)
  ,"TYPE-MAINT-REQ-REPT-CD-01"                       POSITION (207:208)
Char
[Quoted] [Quoted]   ,"EST-LABOR-COST-01"                               POSITION (209:217)
Decimal External ":EST-LABOR-COST-01/100"
  ,"RMRK-CMNT-01"                                    POSITION (218:233)
Char

and here is the error

SQL*Loader: Release 8.0.5.0.0 - Production on Mon Mar 1 15:34:22 1999

(c) Copyright 1998 Oracle Corporation. All rights reserved.

SQL*Loader-930: Error parsing insert statement for column KFM01M."EST-LABOR-COST
-01".
ORA-00984: column not allowed here

>

If I remove the "Decimal External ":EST-LABOR-COST-01/100"" then the loader continues up the list of fields until the next "Decimal ...".

Did I do something, or is it Oracle?

Thank you.

In article <36CB2D28.423413D8_at_erols.com>,   Scott Mattes <smattes_at_erols.com> wrote: <SNIP>
> How do I specify the datatype of a field that is 9(5)v99 (hence the data
> looks like 99999 in the source file)? I am guessing for right now that I
> would say
> DECIMAL EXTERNAL(5) (but, how do I tell it the precision - we need 2?).
> Or, can I do INTEGER EXTERNAL(5) and use some function (at load time) to
> divide it by 100?

Here is how to handle it:
fieldname position(1:5) decimal external ":fieldname/100"

Howard Parks
1 Peter 4:10

-- 
---------------------------------
Scott Mattes
ICQ:  18330579
Work: Scott.Mattes_at_Wang.com
Home: SMattes_at_Erols.com
Web:  www.erols.com/smattes
Received on Mon Mar 01 1999 - 22:19:15 CET

Original text of this message