Stored procedure cursors single-user?

A coworker just told me that if you create a stored procedure with a cursor, that only one cursor instance can exist for any concurrent calls to the stored procedure, so if thirty people want to call a stored procedure, user N can't open the cursor until user N-1 has closed it.

This sounds wrong to me. Is this the case? If that were true, stored procedures wouldn't scale past a few dozen heavy users!

Thanks in advance. Received on Mon Feb 21 2000 - 14:10:51 CST