Skip to Content
0
Former Member
Nov 24, 2006 at 11:19 AM

JDBC Oracle Action on Field type NUMBER !!!

154 Views

Hello all,

I have the following issue to insert or update a field in an oracle database whose type is NUMBER(12)

Value to put for example : 26000

N.B. This field belongs to table key => it appears 2 times in my UPDATE_INSERT STATEMENT !! in access node and in key node....

We tried the following solutions :

1) put type xsd:long in data type and put directly 26000 in XML node

=> Adapter exception ORA-01858: a non-numeric character was found where a numeric was expected

2) put type xsd:string in data type and put directly 26000 in XML node

=> Adapter exception ORA-00904: "26907": invalid identifier

3) put type xsd:string in data type and put value to_number("26000") in XML node

=> Adapter exception ORA-01858: a non-numeric character was found where a numeric was expected

4) put type xsd:string in data type and put value to_number('26000') in XML node

=> Adapter exception ORA-00907: missing right parenthesis

What can we try else ???

Do you have the solution ???

Thanks a lot