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