Todd.Evans
Member
I am attempting to import records from a CSV file using the Overwrite Duplicates option on the Data to Oracle tab of the Text Importer tool. The documentation says "A duplicate record will be updated in the database. Duplicates are based on the primary key value(s) of the table." My Oracle table has a primary key that combines the zgrnyacd_external_id and zgrnyacd_delivery_method columns.
When I try to import the data an ORA-00936: missing expression exception is raised. I've triple check the field mappings and they all look correct to me.
Here is a screen capture of the exception message:
Any help is greatly appreciated.
Todd Evans
When I try to import the data an ORA-00936: missing expression exception is raised. I've triple check the field mappings and they all look correct to me.
Here is a screen capture of the exception message:
Any help is greatly appreciated.
Todd Evans
