perl, oracle a desetinna carka/tecka?

[Honza Pazdziora]

On Tue, Nov 12, 2002 at 12:05:50PM +0100, Michal Dobes wrote:
> 
> NLS_LANG='CZECH_CZECH REPUBLIC.EE8ISO8859P2'
> LANG=cs_CZ
> 
> > Co znamena _presne_ to zkolabuje? 
> 
> DBD::Oracle::st execute failed: ORA-01722: neplatné číslo (DBD ERROR:
> OCIStmtExecute) at ./pok line 17.

Jo, protoze jak CZECH_CZECH REPUBLIC, tak cs_CZ maji jako oddelovat
desetinne cast carku.

> > Jake verze perlu, DBI a DBD::Oracle?
> 
> This is perl, v5.6.0 built for i386-linux
> $DBI::VERSION = "1.20";
> $DBD::Oracle::VERSION = '1.12';
> klient je na linuxu (RH7.1), oracle client 9.0.1
> server je WinNT4, oracle server je 9.2.0.1.0.
> 
> Porad to trva na te carce, takto to take funguje:
> $iv->bind_param(":cislo", "11,5", ORA_NUMBER);
> 
> Preci to musi jit nastavit nejak globalne aspon pro spojeni
> pres alter session?
> Pouzivat vsede to_char/to_number, tak se zblaznim.

Domnivam se, ze co hledate je

	alter session set nls_numeric_characters = ".,"

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
      ... all of these signs saying sorry but we're closed ...
------------------------------------------------------------------------