Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ManagedData Access Core throws exception on Merge statement

user2256623Mar 27 2019 — edited Mar 28 2019

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?

This post has been answered by user2256623 on Mar 27 2019
Jump to Answer

Comments

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
Answer

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.

Marked as Answer by user2256623 · Sep 27 2020
1 - 4

Post Details

Added on Mar 27 2019
4 comments
235 views