Powerhouse 4gl support for Oracle stored procedures

[Darren Reely]

Charles,

 From the 8.3 documentation.

"[RESULT] SET item [,item]...
Limit: This option is valid for SYBASE SQL Server databases only. Only 
one result set can be
returned from a stored procedure."

Perhaps the phantom PowerHouse 8.4 New Features book Bob referred to 
says differently.
Bob, where does one find that on the Cognos site? The latest 
documentation I could find was for 8.3.

If you can perform what you really want with the returned contents of 
procedure calls, that seems to work ok. Just make sure you initialize 
your PL/SQL variables. Since I haven't used PL/SQL previously, I'm not 
sure if it is usual for the variables to keep old content from previous 
calls, as it seems to from Powerhouse calls.

Perhaps it is possible for you to create a view that calls packaged 
functions to do what you want.

Good luck.

Darren


Charles Finley wrote:

>What is the extent of Powerhouse 4gl support for Oracle stored procedures?
>More specifically, does the Powerhouse implementation on Oracle allow for
>returning result sets from stored procedures?
>
>  
>