we have a problem with the following statement:
"select description, price,TO_CHAR(Price,'FM0D00') from materials where TO_CHAR(Price,'FM0D00') like '0,%';"
When we use SQLTalk or ORACLE SqlDeveloper or any other console we get the right result.
When we start this from inside TeamDeveloper 5.1 SP6 we get no result.
NLS_NUMERIC_CHARACTERS is set with alter session to '.,' in the application equal to the consoles.
Is there any solution?
Who is online
Users browsing this forum: [Ccbot] and 4 guests