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

3 次查看（过去 30 天）
Marc Raventós Tato
评论： chrisw23 2023-6-20
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?
  2 个评论
Rik
Rik 2023-6-19
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
chrisw23 2023-6-20
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

请先登录，再进行评论。

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2012b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by