Re: Oracle Cursors with .Net


"emeshuris" <emeshuris@xxxxxxxxx> wrote in message
news:2982ab81-deb2-4c34-8832-d49a4c005b4c@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
Not sure I understand the question. How would you get your data without
opening a cursor? You can't read the datafile directly. If you do a select
.... from .. where ... ; you open a cursor. .net uses the OCI interface to
retrieve data. (so does ODBC, etc. - exception being jdbc thin driver) In
all those cases you open a cursor. What is wrong with opening a cursor?
You seem to imply it is a bad thing.
Jim


.

Relevant Pages

  • Re: Discrepency between SQL/MP Explain plan, actual sequence of IOs
    ... It opens a cursor consisting of a two-table inner join, ... There's a lot of predicate filtering on several of ... Cursor is BROWSE ACCESS. ... Another thing are the statistics ...
    (comp.sys.tandem)
  • Re: URL links dont work in outlook express
    ... hovering your cursor over a link for a preset amount of time will open the ... You click on a hyperlink and an IE window opens but it doesn't load: ... > "PA Bear" wrote in message ... >> Are You Ready for WinXP SP2? ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Word 2003 Slow Startup
    ... Is it just the initial opening that is slow? ... applications, I'd also assume they'd work properly with Word (and the problem ... > after the application opens to when I can do something with the> document ... > cursor goes away, and it takes 20 seconds before the menu dropdown> appears ...
    (microsoft.public.word.application.errors)
  • Re: ADO error - large data set
    ... I was wondering about pagesize or other ... maybe write a small script that adds some data, then opens and closes the ... play around with the locking and cursor ... I use optimistic locking and keyset cursor..nothing out of the ...
    (comp.lang.python)
  • Re: Dont know how to explain
    ... opens and then goes back to the previous page, when I go to favorites at ... top I place the cursor on favorites the menu drops down and before I can ... a friend said it could be my backspace button on the keyboard could ...
    (microsoft.public.windowsxp.general)