The StoredProc object is used for calling a stored procedure in SQL databases. When you’re calling a stored procedure, the StoredProc object takes the place of the Query object in the class hierarchy; it is attached to a Database object that gives access to the SQL database, and it can result in a Rowset object that contains Field objects.

The stored procedure can:

Return values, which are read from the params array

Return a rowset, which is accessed through the rowset property, if the server supports this capability