Oracle REF Cursors

[Darren Reely]

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
>