Re: Delphi / Oracle / Stored Proc

From my understanding of Delphi's interface with Oracle, it cannot return result sets from Oracle Stored procedures. In fact, currently, it can only return one set, and it is written in the Params property of the TStoredProc component. This is what I have been told, having never experimented with it myself. So, someone with more first hand knowledge may know differently.

Currently, you cannot get a return set from an Oracle stored procedure. I don't think this is going to stay the same for much longer. It is my understanding that a) Oracle has modified their Stored Procedures so they can return multiple rows, and b) the BDE will be changed to get those multiple rows to Delphi. I think a) has happened. I can't confirm nor deny if b) is going to be in the next release of Delphi and/or the BDE. It may be worthwhile to see if that is mentioned when they officially release what will be in Delphi 97, or Delphi 3.0 or whatever it's being called.

Good luck,
Ed

marc.scheuner_at_NO.SPAM.PLEASE.ch (Marc Scheuner) wrote:

>Has anyone out there created an Oracle stored procedures that returns
>more than one row of data, and interfaced from Delphi to this stored
>procedure?
 

>I basically know how to create a stored procedure in Oracle that uses
>a cursor to iterate through a set of rows.
 

>I know (and have used) TStoredProc in Delphi, but so far I never tried
>to have one return multiple values.
 

>In Interbase, you can say something like
>
> for select (fields) from (table)
> where (condition)
> into (parameters)
> do
> suspend;
 

>Is there something similar in Oracle? How can I make it clear to the
>Oracle stored procedure that an "outside event" (e.g. a
>"TStoredProc.Next" from Delphi) will fetch the next row of data?
 

>Any hitns are welcome!
>Marc
 

>----------------------------------------------------------------------
>Marc Scheuner, marc.scheuner_at_bernoise.ch CH-3001 BERNE, Switzerland
Received on Wed Feb 05 1997 - 00:00:00 CST