Re: How to retrieve multiple output sets using DBI

How about: (postgres example)

SELECT 'one' UNION SELECT 'two' UNION SELECT 'three';
 ?column?
----------
 one
 two
 three
(3 rows)
[download]

As a computer, I find your faith in technology amusing.

Comment on Re: How to retrieve multiple output sets using DBI Download Code

Replies are listed 'Best First'.
Re^2: How to retrieve multiple output sets using DBI by roho (Bishop) on Feb 08, 2019 at 18:51 UTC
Thanks NetWallah, but I should have mentioned that the multiple selects in my example were just for brevity. I am actually executing a Stored Procedure that generates multiple output sets. The solution suggested by poj displays all the output sets. "It's not how hard you work, it's how much you get done."	[reply]