If the CREATE PROCEDURE or REPLACE PROCEDURE statement for the external stored procedure specifies the DYNAMIC RESULT SETS clause, the external stored procedure can return result sets to the client application or to the caller of the external stored procedure (in addition to consuming the result sets itself) upon completion of the external stored procedure.
A result set is a set of rows that is the result of any of the following statements that the external stored procedure executes:
|
|
An external stored procedure can return up to 15 result sets, depending on the specification of the DYNAMIC RESULT SETS clause.