Format for returning a ResultSet to Matlab via an Oracle Stored Procedure
1 次查看(过去 30 天)
显示 更早的评论
Hello,
I have been having trouble getting a ResultSet into Matlab via an Oracle Stored Procedure. I am using 'exec' and then 'fetch', but I always get an 'Invalid Cursor' message in the cursor struct. I am using a simple query that executes in SQL*Plus, so I know the query is not the problem.
I have tried to create a PL/SQL function that returns a cursor, that doesn't work. I then tried a procedure with one variable as an OUT cursor and that didn't work either. I have tried defining my own cursor and also ref cursor.
Does anybody have a simple stored procedure that illustrates the format that I need to use?
Thanks and any help is much appreciated, Greg
(Using version 2007a)
0 个评论
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!