a bug-fixed runstoredprocedure.​m

There is a bug in the official runstoredprocedure. This file fixed the bug.
Updated 9 May 2011

View License

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
Created with R2010b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!
Version Published Release Notes