Re: Sql*ldr and float dataformat

From: <frank.van.bortel_at_gmail.com>
Date: 16 Aug 2006 06:10:55 -0700
Message-ID: <1155733855.615003.120180_at_b28g2000cwb.googlegroups.com>


ranne schreef:

> Windows XP
> *********************
> Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
> PL/SQL Release 9.2.0.5.0 - Production
> CORE 9.2.0.6.0 Production
> TNS for IBM/AIX RISC System/6000: Version 9.2.0.5.0 - Production
> NLSRTL Version 9.2.0.5.0 - Production

Before you start the SQL*Loader session (sqlldr.exe on WinXP), set you NLS parameters.
set NLS_NUMERIC_CHARACTERS='.,' should do the trick (although I always forget what's what, so maybe you should try ',.') Received on Wed Aug 16 2006 - 15:10:55 CEST

Original text of this message