Hi memrbers,The Workato connector for Oracle SQL is converting whitespace to NULL values when inserting, updating, or upserting data into a table.Specifically, this column (e_mail_address, char (60) ) is defined as NOT NULL in the table schema, and i...
shivakumara,I am using Oracle connector and upsert action.Here is the documentation link: https://docs.workato.com/connectors/oracle/upsert.html#upsert-roworacle upsert
Thanks Shivakumara , for responding.I am not passing an empty string ("") but a single whitespace character (" " with a length of 1). This approach works fine in SQL Script/Developer. However, the Workato Oracle connector does not respect the whitesp...
