OraFAQ Forum: Server Utilities » invalid decimal packed nibble in SQL * LOADER- VEry Urgent

Home » RDBMS Server » Server Utilities » invalid decimal packed nibble in SQL * LOADER- VEry Urgent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

invalid decimal packed nibble in SQL * LOADER- VEry Urgent [message #130411]

Fri, 29 July 2005 17:45

ylsvani
Messages: 2
Registered: July 2005

Junior Member

Hi,
I'm having problem loading decimal values into oracle table. The data file doesn't contain decimal values but as they have already specified the format i need to load it as a decimal just based on the given format.

For Ex: I've a table where

table test
a varchar2(2)
b number(6,3)

data file:

AB+00999
CB+01022

MY CONTROL FILE HAS

load data
...
..
..
into table test replace
a position(1:2) char(2),
b decimal(6,3)

Here though the value of b is +00999 in the 1st record i need to load into the table as 0.999. Can anyone help me with this?

I tried all the possibilities of decimal external,float external etc.

Thanks in advance

[Updated on: Fri, 29 July 2005 17:46]

Report message to a moderator

Re: invalid decimal packed nibble in SQL * LOADER- VEry Urgent [message #130559 is a reply to message #130411]

Mon, 01 August 2005 01:47

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

check this.

http://www.orafaq.com/faq/sql_loader

load data
...
..
..
into table test replace
a position(1:2) char(2),
b decimal(6,3) ":b/1000"

by
vamsi

Report message to a moderator

Re: invalid decimal packed nibble in SQL * LOADER- VEry Urgent [message #130632 is a reply to message #130559]

Mon, 01 August 2005 12:04

ylsvani
Messages: 2
Registered: July 2005

Junior Member

Thanks.

Report message to a moderator

Previous Topic:	Comparing the data in the table with sqlloader control file
Next Topic:	Running batchfile from command prompt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 19:33:22 CST 2024