Like Oracle does sybase have open cursors limit?

In oracle there is initialization parameter - open cursors limit
What is the setting similar to open cursors limit in sybase?

RadhikaGoelAsked:
Who is Participating?
 
jdlambert1Connect With a Mentor Commented:
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
 
knel1234Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.