Menu

#42 ORA-01438 during shp loading

closed-fixed
nobody
5
2012-08-10
2012-01-20
kjanecka
No

Hi, first, thank you for your excellent work and effort!

I have tried to load my shapefile into Oracle XE 10g database using Georaptor 3. Everytime I got this error message:

(GeoRaptor) warn: nazkr_eng( VARCHAR2 (28) ) = Praha
(GeoRaptor) warn: SQL ERROR: ORA-01438: value larger than specified precision allowed for this column.

I think that I understand what the message means but I do not understand why it appears.

I enclose the file (okresy.zip). Everytime 9 out of 10 records are successfully converted.

The error message appears only for the record with attribute NAZKR_ENG = \'Praha\' as reported above although the shapefile contains the larger values in this field.

I will provide you with more details if necessary.

Thank you very much.

Karel

Discussion

  • kjanecka

    kjanecka - 2012-01-20
     
  • Simon Greener

    Simon Greener - 2012-08-10
    • status: open --> closed
     
  • Simon Greener

    Simon Greener - 2012-08-10
    • status: closed --> closed-fixed