Powerhouse 4gl support for Oracle stored procedures

[Whittall, Conrad]

Just to clear this up prior to PowerHouse 8.4D a call to an Oracle stored procedure could only return a single value into a local variable. This was enhanced to support the return of result sets in the just-shipped 8.4D. From the PowerHouse 4GL 8.4D New Features manual (p.16)...

-----

Oracle stored procedures that return result sets are called from PowerHouse in the same way as other database stored procedures. The CALL syntax in PowerHouse that refers to returning result sets is:

   [SQL [IN database] [NOTRANSACTION]] DECLARE name CURSOR FOR
   CALL stored-procedure|stored-function
   ...
   [[RESULT] SET item [,item]...]

-----

A self-extracting zip file containing the setup for the PowerHouse Series 8 Books 3rd Edition (covering PowerHouse 4GL 8.3) can be downloaded by anyone from:

http://powerhouse.cognos.com/products/powerhouse/download.html

All of these manuals, together with the new 8.4D materials, are available on-line (and for saving locally) for supported customers with a web logon at:

http://support.cognos.com/en/support/documentation/

When visiting this on-line Documentation & Utilities Library (a PowerHouse Web application!) you will find that the only documents cross-referenced under PowerHouse 4GL 8.4D are the Release & Install Notes, Getting Started guide, and New Features guide (where the enhanced support for Oracle stored procedures, together with details of the introduction of support for DB2 UDB on UNIX and Windows is documented, including the ability to use DB2 stored procedures). This is because we are expecting a completely new set of PowerHouse Books covering the 8.4D release sometime in the future. To find the existing PowerHouse Books please look under PowerHouse 4GL 8.3.

Hope this helps!

Best regards,
Conrad

Conrad Whittall
Solutions Architect, Global Customer Services, Cognos Incorporated
3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada 
  
       Cognos Forum, June 27-30, 2004: Power Your Performance. Join us in Orlando for our global customer conference. Engage with your peers. Hear from top analysts. Learn from the Cognos Business Intelligence and Enterprise Planning gurus. And turn your potential into higher performance. Register today at http://www.cognos.com/cognosforum 
        This message may contain privileged and/or confidential information.  If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.  Thank you.