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

Discussions specific to Team Developer 5.2.

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

Postby Olive » Wed Sep 16, 2015 9:13 am

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
Olive
 
Posts: 48
Joined: Thu Nov 15, 2007 1:16 am
Location: France

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

Postby Christof » Wed Sep 16, 2015 11:59 pm

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
Christof
 
Posts: 200
Joined: Tue Dec 02, 2008 3:58 pm
Location: Frankfurt/Germany

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

Postby Olive » Thu Sep 17, 2015 2:05 am

Good Idea !

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

Thanks for your help

Olive
Olive
 
Posts: 48
Joined: Thu Nov 15, 2007 1:16 am
Location: France


Return to Team Developer 5.2

Who is online

Users browsing this forum: No registered users and 1 guest