Re: Stored procedure cursors single-user?

From: Richard J Woodland <richwoodland_at_interfacefamily.com>
Date: Mon, 21 Feb 2000 17:28:07 -0500
Message-ID: <38B1BBF7.1111486A@interfacefamily.com>

false.

Rich Woodland
Magic Interface, Ltd.

David Kramer wrote:

> 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 - 16:28:07 CST