Skip to Main Content

Cloud Platform

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!

Want to utilize api from un secure server via secure connection

41e4ac30-01b9-4a9a-a2f1-74cc673cd068Feb 25 2020 — edited Mar 12 2020

I have two applications (api and web client). I want to use api to get data for web app. APi is deployed in Kenya(Africa) on a server, owing to network security issue, we cannot make the ip public. That is why i want to create a secure connection to use api for my web portal which is deployed somewhere in Europe. Does dyn provide such a feature to create secure connection to use api? Please let me know if you did not get my point

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 Feb 25 2020
1 comment
349 views