How can I work with an Oracle SQL function which returns a REF CURSOR in Database Toolbox 3.5.1 (R2009a)?

Question

MathWorks Support Team 2011-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/101295-how-can-i-work-with-an-oracle-sql-function-which-returns-a-ref-cursor-in-database-toolbox-3-5-1-r20

My SQL function in my ORACLE database returns a REF CURSOR. Can I work with this SQL CURSOR object in MATLAB? How can I execute this procudere which returns a REF CURSOR and retrieve the resulting dataset?

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

Answer 1

MathWorks Support Team 2011-11-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/101295-how-can-i-work-with-an-oracle-sql-function-which-returns-a-ref-cursor-in-database-toolbox-3-5-1-r20#answer_110643

To execute the stored procedure use the EXEC function:

result = exec(conn,'SELECT my_package.my_function FROM myTable');

Then you may parse the value manually by working with the Java objects:

%%Get the java object
res = result.ResultSet;
res.next;
res = res.getObject(1);
%%Get the data from the Java object
i=1;
while res.next == 1 % For all rows
      x{i,1}=res.getObject(1); % Get data from 1st column
      x{i,2}=res.getObject(2); % Get data from 2nd column
     % etc
      i = i + 1;
end