Detect if Cursor Opened and Detect if Cursor Allocated 
Author Message
 Detect if Cursor Opened and Detect if Cursor Allocated
1. Can I detect in SQL if a cursor is open (before I close it)?
2. Can I detect in SQL if a cursor is allocated (before I deallocate it)?


Sun, 05 Dec 2004 03:10:53 GMT
 Detect if Cursor Opened and Detect if Cursor Allocated

Check books online for CURSOR_STATUS

-Sue

On Tue, 18 Jun 2002 15:10:53 -0400, "John Irwin"

Quote:

>1. Can I detect in SQL if a cursor is open (before I close it)?
>2. Can I detect in SQL if a cursor is allocated (before I deallocate it)?



Sun, 05 Dec 2004 04:02:11 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Detecting a cursor

2. Detecting data changes using dynamic cursors.

3. Detecting cursors in OnLine 7.x

4. Help ! Opened cursors exceed max opened cursors

5. Open cursors and more open cursors

6. Need Help Please , Invalid Cursor Position Error and Cursor Not Open Error

7. Why declare cursor and open cursor both cost same amount of time

8. Cursor in Trigger - with cursor not open when running second time in the same SQL session

9. 40088 No open cursor or cursor closed.

10. help-no open cursor or cursor closed

11. No open cursor or cursor closed !!!

12. Multiple cursors - second cursor hangs when opened


 
Powered by phpBB® Forum Software