Problem with Decimal sign in ORACLE

[Thhi]

Hello,

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?

Thorsten

[Jeff Luther]

That string you show has a terminating semi-colon (";"). If that same query is what you use in TD, that semi-colon should be removed. If you are using it in TD, that's being sent as part of the statement and Oracle likely doesn't like it.