Result Sets and output parameters are not the same.
Result Set
ResultSets are used to store a
result of a Select query: It can be a one or more columns and it can be a
single row or a full result set or XML. ResultSets are retrieved as ADO
ResultSets and can be stored within variables. It may be
It is in General tab.
None: Insert, update,
delete, create, drop or truncate
Single Row: store the
single row only
Full result set: stored
full result. Data type will be the object type variable.
XML: to store the XML type
records.
Output Parameters or return value
Output Parameters are used to
store some values that can be set any part of the SQL command. Parameters have
the same concept of a SQL stored procedure parameters.
We will get it in the parameter
mapping
Read more about:
