Is it possible to access an Oracle 19 database from MATLAB 2012b using ODBC?

We have some old matlab code we still need to use compiled using matlab 2012b and it stopped working when we updated our database to Oracle 19.

Since then I have been trying to acess the database from matlab without success. I have tried both instantclient 11g and instantclient 19, but none seem to work.

Is this possible?

[Rik]

You might need to contact the person who (or organization which) created the mex interface. Otherwise you may have to try to make changes to the source code and compile it yourself.

[chrisw23]

try the .NET interface. Here are some example lines

NET.addAssembly(fullfile(pwd,'assembly','Oracle.ManagedDataAccess.dll'));

import Oracle.ManagedDataAccess.Client.*

% import Oracle.ManagedDataAccess.Types.*

NET.addAssembly('System.Data');

import System.Data.*

oradb = 'Data Source=ORCL;User Id=hr;Password=hr;';

myOraConnection = OracleConnection(oradb); % Oracle.ManagedDataAccess.Client.OracleConnection

myOraConnection.Open();

myOraCmd = OracleCommand(); % Oracle.ManagedDataAccess.Client.OracleCommand

myOraCmd.Connection = myOraConnection;

myOraCmd.Text = 'select ...';

myOraCmd.Type = CommandType.Text; % System.Data enum Text/StoredProcedure/TableDirect

myOraDataReader = myOraCmd.ExecuteReader();

if myOraDataReader.Read()

qString = myOraDataReader.GetString(0);

else

disp('...file not found');

end