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 |