How do I execute a stored procedure with the Database Toolbox?
2 views (last 30 days)
Show older comments
I would like to execute a stored procedure with the Database Toolbox.
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
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.
0 Comments
More Answers (0)
See Also
See Also
Categories
Find more on Multirate Signal Processing in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!