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\
Cite As
Zhiqiang Zhang (2024). a bug-fixed runstoredprocedure.m (https://www.mathworks.com/matlabcentral/fileexchange/31365-a-bug-fixed-runstoredprocedure-m), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |