And Oracle just keeps getting weirder. Anyone know what to do about this one? https://dba.stackexchange.com/questions/292033/

looks like someone just responded to your quesiton.

yeah, just saw that

have you been able to get it to write one record at a time using the batch syntax?

haven't tried. Currently trying a different workaround

any luck?

Not yet. It appears that somewhere along the line, errors are getting swallowed and never making it back to me. Trying to track down the root problem.

what was the issue here?

The issue was that I copied the CREATE TABLE statement from the SQL Server version, and Oracle doesn't have any concept of

VARCHAR(MAX)

. And for whatever reason, when that failed in dynamic SQL, it didn't surface any sort of error message back to the test code.