https://linen.dev logo
m

Mason Wheeler

05/21/2021, 7:06 PM
And Oracle just keeps getting weirder. Anyone know what to do about this one? https://dba.stackexchange.com/questions/292033/
u

user

05/21/2021, 7:27 PM
looks like someone just responded to your quesiton.
u

user

05/21/2021, 7:27 PM
yeah, just saw that
u

user

05/21/2021, 7:27 PM
have you been able to get it to write one record at a time using the batch syntax?
u

user

05/21/2021, 7:28 PM
haven't tried. Currently trying a different workaround
u

user

05/21/2021, 8:01 PM
any luck?
u

user

05/21/2021, 8:02 PM
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.
u

user

05/21/2021, 11:30 PM
what was the issue here?
u

user

05/21/2021, 11:32 PM
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.