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

Discussion forum about all things SqlBase.
Olive

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

Post by Olive » 16 Sep 2015, 17:13

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 :oops:

Any other ideas ?
Thanks for your help
Best regards
Olivier

Christof
Germany
Posts: 191
Joined: 06 Mar 2017, 07:27
Location: Frankfurt, Germany

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

Post by Christof » 17 Sep 2015, 07:59

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

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

Post by Olive » 17 Sep 2015, 10:05

Good Idea !

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

Thanks for your help

Olive

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests