Writing numeric data to Oracle does not work

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

Output

In Database

In-Database

Accepted answers

MichalK

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

All comments

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703