How do I execute a stored procedure with the Database Toolbox?

I would like to execute a stored procedure with the Database Toolbox.

Answer 1

[MathWorks Support Team]

This feature has been added in the Database Toolbox 3.2 (R2006b). You can use the RUNSTOREDPROCEDURE function. If you are using a previous version, read below for any workarounds.

Assuming that you set up the initial connection to the database, you can execute the procedures using the EXEC command. There are two kinds of procedures, those that do not take any input arguments and those that take one or more arguments.

To execute procedures that do not take any arguments:

          exec(c,'stored_procedure')

To execute procedures that take one or more input arguments:

         exec(c,'{call sp_name(input1, input2,...)}')

Note the curly braces in the above command.