perl, oracle a desetinna carka/tecka?

[Michal Dobes]

Honza Pazdziora wrote:
> Vase presne NLS nastaveni a locales? 

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.

> 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.

	Majkl