Not everyone knows, but from 12c version of Oracle DB lot of things are changing, just take a look on below: Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. … More Oracle 12c and .Net – new world
Firstly, I thought that it can’t be complicated task. But Oracle surprised me again, so I looked for some solution. The post, which I found, describes how to do that in very clever way. And now, everything is simpler 😉 Update: Additionally thing, if someone wants to refresh PL/SQL knowledge – go to the link.