Output Data Tool Error -- ORA-01008 -- Oracle Database

Question

I am trying to output data into an Oracle database table.  I want the workflow to update existing data entries or insert new entries if new.

However, I am getting an odd error.  Can anyone offer some advice on how to fix this?  I am 100% sure that the field names are correct.

Error: Output Data (85): DataWrap2OCI::SendBatch: ORA-01008: not all variables bound

Insert into EMSRPT.IDOC_LOG(IDOC_NUM,CREATED_DATE,MSG_TYPE,BASIC_TYPE,STATUS,MSG_VAR,RESOLVED_FLAG,RESOLVED_DATE) Values (:A1,:A2,:A3,:A4,:A6,:A5,:A7,:A8)

cmcclellan · Accepted Answer

WOW, it's been a LONG time since I had to deal with bind variables in Oracle :)

Without going too far down the technical path, the easy Alteryx-style answer is "check your field mappings". There must be a field that is in the workflow that you're not linking properly in the output tool.  To solve that, the usual method I use is a Select tool just before the output so you can see what's going to be fed to the Output tool and you have a place to change datatypes (etc) if you need to