OraFAQ Forum: SQL & PL/SQL » To_number and nls_numeric

Home » SQL & PL/SQL » SQL & PL/SQL » To_number and nls_numeric_characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To_number and nls_numeric_characters [message #48369]

Tue, 16 November 2004 23:20

Milly
Messages: 72
Registered: March 2004

Member

Hi all!

I have this problem:

when I launch my function (with a replace (...".", ",")) with my client oracle there's no problem, but when I use another client..it doesn't work.

to overdo this, I'm using the nls_numeric in the to_nmber function

to_number(replace(v_quotazione,'.',','),nls_numeric_characters =', ') and it doesn't owrk!!

any idea?

thanks!

Report message to a moderator

Re: To_number and nls_numeric_characters [message #48375 is a reply to message #48369]

Wed, 17 November 2004 05:05

Edward Stoever
Messages: 58
Registered: August 2002

Member

Try this:

 replace (to_char(my_variable),".", ","))

I would be really surprised if that doesn't fix it.

Edward -- www.database-expert.com

Report message to a moderator

Re: To_number and nls_numeric_characters [message #48384 is a reply to message #48375]

Wed, 17 November 2004 06:32

Padders
Messages: 79
Registered: January 2004

Member

I hope you like surprises.

Report message to a moderator

Previous Topic:	Please need help ASAP.
Next Topic:	using pl/sql type outside a package where it is declared?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 26 12:09:41 CDT 2025