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

Jun 27 '08 #1

Subscribe Post Reply

858

Alvin Bruney [ASP.NET MVP]

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" <em*******@gmail.comwrote in message
news:f0**********************************@u12g2000 prd.googlegroups.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

Jun 27 '08 #2

Similar topics

oracle function

by: chripa | last post by:

Hi all I use php with oracle database and i need function like mysql_data_seek i need to set the result pointer to the row number I need. can anyone help me? Thank you Chripa

PHP

Oracle to Mysql, I'm (still) lost...

by: duikboot | last post by:

Hello all, I still can't convert Oracle tables to a Mysql database. See thread: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=utf-8&threadm=mailman....

Python

Oracle Stored Procedures VERSUS SQL Server Stored Procedures

by: jrefactors | last post by:

I want to know the differences between SQL Server 2000 stored procedures and oracle stored procedures? Do they have different syntax? The concept should be the same that the stored procedures...

Microsoft SQL Server

Javascript, ODBC, and Oracle functions returning cursors

by: Roger Redford | last post by:

Dear Experts, I'm attempting to marry a system to an Oracle 817 datbase. Oracle is my specialty, the back end mainly, so I don't know much about java or javascript. The system uses javascript...

Javascript

Oracle Open Cursor Problem?

by: Adam Right | last post by:

Hi, I am developing a program with visual studio 2005 beta using C#. I have a problem about opened cursors on my Oracle 9i database. I cannot dispose opened cursors although there is a close...

C# / C Sharp

Oracle Client, stored procedures and Cursor release.

by: bclegg | last post by:

Hi, Does anybody know if it possible to force Oracle to release cursors that have been generated when servicing a vb.net stored procedure call? ie My app makes a call that populates a field in a...

Visual Basic .NET

Patience for a Oracle Noobie

by: Chad | last post by:

Hi, I am a SQL Server programmer using Oracle for the first time. In our .NET client apps which use a SQL Server back end, we would use Stored Procedure exclusively for all database access for...

Oracle Database

Max Cursor error using Oracle

by: sfayed | last post by:

Hello, Does anyone have a good solution to close cursors when using Oracle 9 with VB.NET. I have tried disposing of the command object, the data adapter and increasing the OPEN_CURSORS variable...

Visual Basic .NET

converting DB2 triggers to Oracle

by: --CELKO-- | last post by:

I need to convert a bunch of DB2 triggers to Oracle. Is there any kind of tools for this?

DB2 Database

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice