?
Solved

Like Oracle does sybase have open cursors limit?

Posted on 2004-08-14
4
Medium Priority
?
408 Views
Last Modified: 2010-05-18
In oracle there is initialization parameter - open cursors limit
What is the setting similar to open cursors limit in sybase?

0
Comment
Question by:RadhikaGoel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 80 total points
ID: 11800825
Sybase doesn't have a cursor-limit parameter. The practical limit is imposed by other things, such as the amount of RAM, I/O, etc. If you make sure any code that opens a cursor closes it and deallocates it, it's unlikely this will ever be a problem. Note the last two lines in this example:

DECLARE Cur1 CURSOR READ_ONLY FOR SELECT name FROM TableA

DECLARE @name varchar(40)
OPEN Cur1

...<loop>

CLOSE Cur1
DEALLOCATE Cur1

0
 
LVL 3

Expert Comment

by:knel1234
ID: 11932206
Hi,

While I appreciate your question is specifically relating to a cursor, I am curious about your need for a cursor.  Having working with Sybase, MSSQL, and Oracle.  I have found that I rarely use cursors except in Oracle.  What do you need the cursor for??


knel
0

Featured Post

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The well known Cerber ransomware continues to spread this summer through spear phishing email campaigns targeting enterprises. Learn how it easily bypasses traditional defenses - and what you can do to protect your data.
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question