a bug-fixed runstoredprocedure.m
There is a bug in the runstoredprocedure when query a stored procedure of Oracle database.
bug example: let c be a connection object of an Oracle database, when you query an stored procedure with a string input, like blows:
x = runstoredprocedure(c,'myprocinonly',{2500,'Jones'})
Then error occurs:
??? Java exception occurred:
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'myproc'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(Unknown Source)
The bug-fix is very simple, replace the 53-th line in runstoredprocedure to following:
else%if strcmp(sDbName,'MySQL') || strcmp(sDbName,'Microsoft SQL Server')
or download the attachment, and replace the runstoredprocedure.m under your \toolbox\database\database\@database\
引用
Zhiqiang Zhang (2024). a bug-fixed runstoredprocedure.m (https://www.mathworks.com/matlabcentral/fileexchange/31365-a-bug-fixed-runstoredprocedure-m), MATLAB Central File Exchange. 取得済み .
MATLAB リリースの互換性
プラットフォームの互換性
Windows macOS Linuxカテゴリ
タグ
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!バージョン | 公開済み | リリース ノート | |
---|---|---|---|
1.0.0.0 |