I have a very weird issue with Oracle ODBC connection. I know it isn’t UiPath specific, but we are having issues when returning a number(20,2) field that contains a value between 0 and 1, like 0.19.
Then it fails with the error: input string was not in a correct format.
I know I can solve this by writing TO_NUMBER(coloumn), but I wonder why it fails.
Does anyone else work with Oracle databases? and do you have a suggestion to this?
Using Oracle SQLDeveloper it works perfect, I can’t get any errors, but using the InstantClient ODBC it fails.
I have been googling and searching the forum without any answers.