File Exchange

image thumbnail

a bug-fixed runstoredprocedure.​m

version 1.0 (2.15 KB) by

There is a bug in the official runstoredprocedure. This file fixed the bug.



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\

Comments and Ratings (0)

MATLAB Release
MATLAB 7.11 (R2010b)
Tags Add Tags

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video

Win prizes and improve your MATLAB skills

Play today