ManagedData Access Core throws exception on Merge statement

user2256623

Having an issue with ManagedData Access for .Net Core driver.

if I use a MERGE statement, the action happens, but then the driver also throws a Oracle exception 12537 (ORA number). 

since the merge seems to work, i'm catching this error and swallowing it, but it does seem like something we shouldn't have to do.  Any thoughts?

Is there anything special about how a merge statement should be called that's different from inserts or updates that seem to work fine?

user2256623

just updated to the latest .net core driver from a few days ago and seems to be fixed.

we had previously found a thread stating that .net core drivers were having an issue with stored procedures and returning similar errors, so we figured it was related to that.

Alex Keh-Oracle

We haven't seen this before. Is there a secondary ORA error, such as in an inner exception alongside the ORA-12537? Also, what is the ORA-12537 error message itself, which can point to the likely problem source?

Molonator69

Sorry for my english, but, can you test if connection is open before the statement?.

user2256623

yes, the connection is definitely open, as mentioned in the OP, the merge statement actually works and does what it's supposed to in the DB.  could it be a problem in the way it returns the RowsAffected that's different from regular Insert/update statements? 

user2256623

just updated to the latest .net core driver from a few days ago and seems to be fixed.

we had previously found a thread stating that .net core drivers were having an issue with stored procedures and returning similar errors, so we figured it was related to that.