Easyloader
Uffe Kousgaard
works OK unless I have any decimal fields. Then I get error ORA-01722 on a
number such as 0.000. As far as I can see I use . as decimal comma on both
server and client everywhere, but still I get this error.
Any ideas what to look for? Use version 9.0 instead?
Regards
Uffe Kousgaard
Uffe Kousgaard
Now I have tried with 9.0.2 and I still get the same error. Is anybody
having success with this combination?
Regards
Uffe Kousgaard
Ben A Greenberg
does anyone know where i can download Easyloader v 8.5?
the download available on the PB MI site only allows you do download v9 (which of course requires MI PRO 9)
even though the link on the web site says its for downloading v8.5
Ben Greenberg
GIS Coordinator
NAI MLG Commercial
262-797-9400
b...@mlgcommercial.com
Peter Horsbøll Møller
Found this old thread, don't know if it makes sense:
http://news.geocomm.com/community/lists/viewmessage.phtml?id=28367 <http://news.geocomm.com/community/lists/viewmessage.phtml?id=28367>
> 1) You decimal seperator specified in windows is something other than
> the the dot "." symbol.
>
> 2) You Oracle settings are set up for a Unicode or other default
> character set that also uses something other than the dot "." as the
> decimal seperator.
Peter Horsbøll Møller
GIS Developer, MTM
Geographical Information & IT
COWI A/S
Odensevej 95
5260 Odense S.
Denmark
Tel + 45 6311 4900
Dir +45 6311 4908
Mob +45 5156 1045
Fax + 45 6311 4949
E-mail p...@cowi.dk
http://www.cowi.dk <http://www.cowi.dk/>
________________________________
From: mapi...@googlegroups.com on behalf of Uffe Kousgaard
Sent: Fri 04-Jan-08 16:55
To: mapi...@googlegroups.com
Subject: [MI-L] Re: Easyloader
Uffe Kousgaard
> character set that also uses something other than the dot "." as the
> decimal seperator.
Thanks to Peter Horsbøll Møller.
The solution is to add the system variable NLS_NUMERIC_CHARACTERS with value
".," (skip " when typing) on the client pc. Now Easyloader also works fine.
Regards
Uffe Kousgaard