User`s guide

runstoredprocedure
7-215
Here, the narrow unit cost range returns only one product. If the unit cost range is
wider, then more than one product might satisfy this condition. To return a data set
with numerous products, use exec and fetch to call this stored procedure. Otherwise,
runstoredprocedure returns only the last row in the data set.
Close the database connection conn.
close(conn)
• “Call a Stored Procedure That Returns Data”
Input Arguments
conn — Database connection
database connection object
Database connection, specified as a database connection object created using database.
spname — Stored procedure name
string
Stored procedure name, specified as a string that contains the name of the stored
procedure that is defined and instantiated in your database.
Data Types: char
inputargs — Input arguments
cell array
Input arguments, specified as a cell array of one or more values for each input argument
of the stored procedure. Input arguments can be only basic data types such as double,
string, logical, and so on.
Data Types: cell
outputtypes — Output types
cell array
Output types, specified as a cell array of one or more Java data types for the
output arguments of the stored procedure. Some JDBC drivers do not support all
java.sql.Types. Consult your JDBC driver documentation to find the supported types.
Match them to the data types found in your stored procedure.