Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Delphi and ORACLE REF CURSOR

Re: Delphi and ORACLE REF CURSOR

From: Helmut Hahn <helmut.hahn_at_bitoek.uni-bayreuth.de>
Date: Fri, 22 Dec 2000 09:20:58 +0100
Message-ID: <3A430EEA.3712A9C3@bitoek.uni-bayreuth.de>

leduc_nicole_at_my-deja.com schrieb:

> I'm wondering how to manage stored procs with REF CURSOR, with code.
> Not with components, see ?

Yes. It works with a TStoredProc. You must set the REF CURSOR Parameter to

Result in the Params of the TStoredProc.

hth
Helmut

>
>
> Something like :
> while not MyQuery.Eof do
> begin
> // working with MyQuery stuff
> MyQuery.Next;
> end;
> But with the Stored Proc, returning REF CURSOR (instead of a Query) in
> the code above.
>
> Any idea ?
> Nicole
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 22 2000 - 02:20:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US