How are you authenticating to the Oracle server?

CDC can't filtered by user. It's a system process capturing changes on the table level from the log.

After Rollback you could update the log with the error in the CATCH. Using transaction variables (named transactions) could help you quickly identify where in the procedure an error occurs...

Please post consumable data, create table XXX(col int, …); insert XXX values(…)

It's likely you need to join the table you're loading from to the tables referenced by the foreign keys so you can insert the correct values.

Thank for the correction Lynn

Starting with SQL Server 2008 user-defined table type is an option allowing passing "tables"...

Check this topic

Or a staging table

I suggest SSIS for this type of task. It's easier to connect from Excel to SQL Server to get back data in the correct data types using the Data tab...

May 31, 2018 at 3:45 pm

#1992573

SELECT [Date], Amount