Oracle Cursors with .Net

[emeshuris]

Hi,
I am having an argument with our DBA, he is under the impression that
it is the .net api always opens a cursor.
However I believe that Oracle always opens a cursor for any select
statement.
Can someone shed some light?
Regardless of what the answer is, why is it that oracle relies so
heavily on cursors?

-Edward

[Alvin Bruney [ASP.NET MVP]]

Re: Oracle Cursors with .Net

because they are fast and light weight. There is an Ado.net group that you
should post to for an answer on your first question.

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------


"emeshuris" <emeshuris@gmai l.comwrote in message
news:f09cb145-bf72-46de-a7c4-555bb77e96de@u1 2g2000prd.googl egroups.com...

Hi,
I am having an argument with our DBA, he is under the impression that
it is the .net api always opens a cursor.
However I believe that Oracle always opens a cursor for any select
statement.
Can someone shed some light?
Regardless of what the answer is, why is it that oracle relies so
heavily on cursors?
>
-Edward