Oracle REF Cursors

[Peter Bateman]

John:

  Sorry, I missed the CALL procedure aspect of your question.

  As a workaround one could in the stored procedure populate a table with 
the result set and then read the table in QUICK.



Regards,
Peter






>From: Darren Reely <darren.reely@latticesemi.com>
>To: "'powerh-l@lists.swau.edu'" <powerh-l@lists.swau.edu>
>CC: John Hunter <jthunter@nbnet.nb.ca>
>Subject: Re: Oracle REF Cursors
>Date: Wed, 18 Dec 2002 09:57:56 -0800
>
>You can use Oracle procedures but the documentation says result sets only 
>work with Sybase.  My documention is for 8.3 and published August 2001.  
>Perhaps things have changed since then.
>
>Here is a simplified sample from one of our Quick programs to retrieve some 
>data.  Hope it helps in some way.
>
>temp n_product      varchar*24
>temp o_line_1        varchar*28
>temp o_line_2        varchar*28
>
>procedure internal get_topmark
>begin
>        SQL IN mfg CALL TOPMARK_PKG.GET_TOPMARK(n_product IN  &
>                                                ,o_line_1 OUT  &
>                                                ,o_line_2 OUT )  &
>                                        ON ERROR CONTINUE
>
>        if NOT SQLOK
>        then error = SQLMESSAGE
>end
>
>
>Darren.
>
>John Hunter wrote:
>
>>Hi,
>>
>>Does anyone know if it's possible to access an Oracle Procedure that 
>>returns a REF Cursor from Powerhouse?
>>
>>We are able to declare cursors and use them in powerhouse, but
>>we haven't found a way to use a ref cursor returned from a oracle 
>>procedure.
>>
>>Any hints?
>>
>>We are Using Oracle 8.1.7.4.0 and PowerHouse  8.20.D7 on Open VMS
>>
>>Thanks,
>>-John
>>
>
>
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to 
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail