Hello,
we have upgraded the OneIM from version to 9.2 - so there is no more Devart components. So I have replaced the logic using Oracle.ManagedDataAccess.Client (as suggested in the script samples in the installation folder), but when I try to run the script I get "Oracle is not supported anymore" error. Version of the Oracle database is 19c. Any suggestions?
References Oracle.ManagedDataAccess.dll
Imports Oracle.ManagedDataAccess.Client
Public Sub CCC_ProcedureCall(ByVal myQuery As String)
Try
Dim connectionString As String = Session.Config.GetConfigParm("Custom\Oracle\Account\ConnectionStringUAT")
Dim dbFac As IDbFactory = DbApp.GetFactoryByName("VI.DB.Oracle.ViOracleFactory,VI.DB.Oracle")
Using sf = DbApp.ConnectTo(connectionString).Using(dbFac).BuildSessionFactory()
Using dbSession = sf.OpenDbSession()
dbSession.SqlExecuteNonQuery(myQuery)
End Using
End Using
Catch ex As Exception
' Handle Exceptions
Throw New Exception(ex.Message())
End Try
End Sub
Best Regards,
Jernej