Writing numeric data to Oracle does not work

[MichalK]

Hi,

I have a workflow that writes data into an existing table in Oracle database.

One of my fields contains a numeric value (set to 'Int32' type in Alteryx), and I'm writing it to an Oracle field set up as 'Number' type. Unfortunately, when I run the workflow the number field is populated with an empty value. I'm using 'Write Data In-DB' tool to write into DB.

Any tips on which Alteryx format to use and what may be the cause for this?

Thanks,

Michal

[JoeS]

Hi @MichalK

If you read from that table, what data type is that field?

The driver should be able to map things for you, but if you make sure you set it to the same that's it's read as then hopefully that will fix the error for you.

Thanks

Joe

[MichalK · Accepted solution]

I found the bug - it had nothing to do with formatting, I had some trailing whitespace in the field name...

[JoeS]

Ah, glad you got to the bottom of it!