Strange Problem!!!!!

[oravijay]

Hi,

We have a table with the following structure:
LOC_LOC VARCHAR2(9)
LOC_REFNO NUMBER(6)
LOC_DEDICATED VARCHAR2(1)
LOC_FLG_2 VARCHAR2(1)
LOC_FLG_3 VARCHAR2(1)
LOC_FLG_4 VARCHAR2(1)
LOC_FLG_5 VARCHAR2(1)
LOC_FLG_6 VARCHAR2(1)
LOC_FLG_7 VARCHAR2(1)
LOC_FLG_8 VARCHAR2(1)
LOC_BIN_SIZE_CAT VARCHAR2(1)
LOC_BIN_SIZE_CD NUMBER(3)
LOC_BIN_SIZE_SFX VARCHAR2(1)
LOC_WRHS NUMBER(1)
LOC_ACCESS_1 NUMBER(1)
LOC_ACCESS_2 NUMBER(1)
LOC_ACCESS_3 NUMBER(1)
LOC_RELATIVITY NUMBER(1)
LOC_NOMINATION NUMBER(1)
LOC_ALLOC NUMBER(1)
LOC_PALLETS NUMBER(2)
LOC_QTY NUMBER(7)
LOC_MAX_QTY NUMBER(7)
LOC_MNT_YMD DATE
LOC_CYC_CT_YMD DATE
LOC_REFILL_CT NUMBER(3)
LOC_CREATED_TIMESTAMP DATE
LOC_LAST_UPDATED_TIMESTAMP DATE

After loading data into this table using a script I found the following:


1* select LOC_MAX_QTY,loc_loc from naloc_err where loc_refno = 78053
SQL> /

LOC_MAX_QTY LOC_LOC
----------- ---------
6.0000E+34 FZ1702L3

The column LOC_MAX_QTY is declared with number(7). I am wondering how Oracle inserted a value like this.

Please clarify.

Thanks

[ggnanaraj]

Try increasing the width to (say 14), then do the load. Most probably, the number inserted was big for LOC_MAX_QTY column.

You can do yet another thing before doing the above. select the column with a suitable length.
eg.,

SELECT RPAD(LOC_MAX_QTY,40) FROM ;

HTH.


[Edited by ggnanaraj on 07-04-2002 at 07:02 AM]

[marist89]

duplicate post, closing http://www.dbasupport.com/forums/sho...threadid=26728