perl, oracle a desetinna carka/tecka?
Honza Pazdziora
adelton na informatics.muni.cz
Úterý Listopad 12 12:26:59 CET 2002
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 ...
------------------------------------------------------------------------
Další informace o konferenci Databases