Re: Fetch row into Powerduilder From Oracle Stored Procedure.

I have never used PowerBuilder with Oracle, but according to PowerBuilder's help, you cannot return a multiple row result set without using embedded SQL (I tried pasting the text of the help into this message, but the formatting came out badly). Check PowerBuilder's help on using stored procedures with Oracle - it looks pretty comprehensive.

eric wrote:

> I can fetch multi row result set into Powerbuilder's datawindow by calling
> Stored Procedure from SQL Sever and Sybase, but not from Oracle. It is
> because Oracle's stored procedure is limited to return a single row result
> set ( limited by the Select ... INTO .. clause). Is that true? Is that other
> way?
>
> I also tried to use REF CURSOR but don't know if Powerbuilder supplort it or
> not.
>
> The point is that I don't want to have the SQL written locally in
> Powerbuilder. I want to have them all stored in Oracle.
>
> Your advise is much appreciated.
>
> Eric.
> tsangh_at_asiaonline.net
Received on Sun Dec 20 1998 - 00:03:54 CST