And Mr. Brian Gale is the winner. It was a data issue all along, totally my bad. As Brian questioned, it would remove references via 1 row of the "ship...

The space is part of the data structure. it's dumb, ERP dev does it this way though.

I think Mr Gale may be on to something though. I tweaked it a...

In the attached image I am showing the results of the SELECT statements. The first result set is inside the nested cursor the 2nd result set is inside the top...

I have several BEGIN/END blocks in my code, mostly for organizational purposes. That wouldn't do it, would it?

Rollback in trigger is an interesting thought, but no, just checked and confirmed no transactions at all in the 3 triggers on that table. The ERP expects the middleware data...

I am 100% sure the update is not missing the records. I put in SELECT statements to show me the data at various points in the script. The select statement...

There are no other transaction statements in the script. No rollbacks or commits. I've used find to search for "tran", "commit", and "rollback" just to make sure I am not...