[
https://issues.apache.org/jira/browse/HIVE-11254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14629814#comment-14629814
]
Dmitry Tolpeko commented on HIVE-11254:
---------------------------------------
DB2 approach:
{code}
DECLARE loc RESULT_SET_LOCATOR VARYING;
CALL spResultSet1;
ASSOCIATE RESULT SET LOCATOR (loc) WITH PROCEDURE spResultSet1;
ALLOCATE c1 CURSOR FOR RESULT SET loc1;
FETCH c1 INTO v1, v2;
{code}
> Process result sets returned by a stored procedure
> --------------------------------------------------
>
> Key: HIVE-11254
> URL: https://issues.apache.org/jira/browse/HIVE-11254
> Project: Hive
> Issue Type: Improvement
> Components: hpl/sql
> Reporter: Dmitry Tolpeko
> Assignee: Dmitry Tolpeko
>
> Stored procedure can return one or more result sets. A caller should be able
> to process them.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
