Board index » delphi » Delphi and ORACLE REF CURSOR

Delphi and ORACLE REF CURSOR

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

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/

 

Re:Delphi and ORACLE REF CURSOR


Go to www.greenhousemm.com and download TQueryProc
It is just perfect for your needs.

Quote
On Wed, 20 Dec 2000 10:27:24 GMT, leduc_nic...@my-deja.com wrote:
>I'm wondering how to manage stored procs with REF CURSOR, with code.
>Not with components, see ?

>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/

Regards,
E.Beli
http://www.greenhousemm.com

Other Threads