Using Result Sets in PH 8.23 with Oracle 8i Stored Procedures?

Tue, 30 Oct 2001 09:30:21 +0100

Hi,

I'm trying to find out whether there is support for retrieving Result Set's
from Oracle 8i stored procedures. We are in the middle of moving from PH
8.19 and HP3000/MPE to PH 8.23 on HP-UX with Oracle 8i, and are quite new
to PH and relational databases.
According to the manuals, version 8.19, and a tutorial on "the PowerHouse
Relational Interface" it is only with SYBASE Sql Server result sets are
supported. But since Oracle now are supporting numerous out-parameters from
stored procedures I am wondering if PowerHouse has undocumented support?
Has anyone tried this out?

Any help is highly appreciated. Thanks in advance.

Kim Bjørn Jensen

Lindorff Applications AS
www.lindorffapplications.com
Norway