Powerhouse 4gl support for Oracle stored procedures
Joe Boyle
joeboyle_adt@hotmail.com
Fri, 30 Apr 2004 14:00:47 +0100
<html><div style='background-color:'><DIV class=RTE>
<P>it may be the case that there are worked examples of handling both Oracle and SQLServer calls to stored procedures and stored functions at the Cognos knowledge base web site. If the new Oracle result set syntax is similar to SQLServer/Sybase you may get a head start there.<BR><BR></P></DIV>
<DIV></DIV>>From: Darren Reely <darren.reely@latticesemi.com>
<DIV></DIV>>To: Powerh-L <powerh-l@lists.sowder.com>
<DIV></DIV>>CC: Charles Finley <cfinley@xformix.com>
<DIV></DIV>>Subject: Re: Powerhouse 4gl support for Oracle stored procedures
<DIV></DIV>>Date: Thu, 29 Apr 2004 14:17:58 -0700
<DIV></DIV>>
<DIV></DIV>>Charles,
<DIV></DIV>>
<DIV></DIV>>From the 8.3 documentation.
<DIV></DIV>>
<DIV></DIV>>"[RESULT] SET item [,item]...
<DIV></DIV>>Limit: This option is valid for SYBASE SQL Server databases only.
<DIV></DIV>>Only one result set can be
<DIV></DIV>>returned from a stored procedure."
<DIV></DIV>>
<DIV></DIV>>Perhaps the phantom PowerHouse 8.4 New Features book Bob referred to
<DIV></DIV>>says differently.
<DIV></DIV>>Bob, where does one find that on the Cognos site? The latest
<DIV></DIV>>documentation I could find was for 8.3.
<DIV></DIV>>
<DIV></DIV>>If you can perform what you really want with the returned contents
<DIV></DIV>>of procedure calls, that seems to work ok. Just make sure you
<DIV></DIV>>initialize your PL/SQL variables. Since I haven't used PL/SQL
<DIV></DIV>>previously, I'm not sure if it is usual for the variables to keep
<DIV></DIV>>old content from previous calls, as it seems to from Powerhouse
<DIV></DIV>>calls.
<DIV></DIV>>
<DIV></DIV>>Perhaps it is possible for you to create a view that calls packaged
<DIV></DIV>>functions to do what you want.
<DIV></DIV>>
<DIV></DIV>>Good luck.
<DIV></DIV>>
<DIV></DIV>>Darren
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Charles Finley wrote:
<DIV></DIV>>
<DIV></DIV>>>What is the extent of Powerhouse 4gl support for Oracle stored
<DIV></DIV>>>procedures?
<DIV></DIV>>>More specifically, does the Powerhouse implementation on Oracle
<DIV></DIV>>>allow for
<DIV></DIV>>>returning result sets from stored procedures?
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>>
<DIV></DIV>>
<DIV></DIV>>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
<DIV></DIV>>Mailing list: powerh-l@lists.sowder.com
<DIV></DIV>>Subscribe: "subscribe" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>Unsubscribe: "unsubscribe <password>" in message body to
<DIV></DIV>>powerh-l-request@lists.sowder.com
<DIV></DIV>>http://lists.sowder.com/mailman/listinfo/powerh-l
<DIV></DIV>>This list is closed, thus to post to the list you must be a
<DIV></DIV>>subscriber.
<DIV></DIV></div><br clear=all><hr>Have more fun with your phone - download ringtones, logos, screensavers, games & more. <a href="http://g.msn.com/8HMAENUK/2746??PS=">Click here to begin!</a> </html>