00104-Attempt to fetch non-num.. not allowed here !

[Olive]

Hi

One of my software prepares, executes and fetches many sql Statements, all, expected these return decimal values, since we have changed OS and oracle sqlnet

The error is "00104 : Attempt to fetch non-numeric data into numeric column"

Configuration
- Centura 5.2 SP5
- Windows seven
- Oracle database 10.2.0.2.0
- Oracle sqlnet 11.2.0.3.0 - 64bit

I attach for you the oracle log generated by Centura
the error is fired when I fetch the second line of the result set into my bind variables (see line 423 in the attached file :
9/16/15 17:28:53 4> fetch data [2:11]
9/16/15 17:28:53 4> 3230322C 33 |202,3 |
)
the statement is in line 75 (sorry it's long)
See the value is 202,3
Maybe the value 202.3 would be better ?

the same soft works well under Xp/sqlnet 9/oracle db 10

I already tried :
1) substitute=,, it doesn't work (not accepted by Centura, because "," is a separator)
2) change the regional parameters, it doesn't work anymore
3) change sqlnet parameter, I didn't try this, I don't know to do that

Any other ideas ?
Thanks for your help
Best regards
Olivier

[Christof]

Just guessing, may be due to the change of the OS, you've got different defaults for decimal and group separator characters.

Do you do any Oracle session settings in your application? Something like "ALTER SESSION SET NLS_NUMERIC_CHARACTERS = '.,'". This could help.

Good luck
Christof

[Olive]

Good Idea !

It works well
I didn't think to that, I'm getting old

Thanks for your help

Olive