Re: SQL Loader question
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/smattesReceived on Mon Mar 01 1999 - 22:19:15 CET