On 12/3/2010 5:56 AM, chris.waldmann wrote:

> In a stored procedure I use two cursors to compare two result set row by row.
>
> I want to use the same stored procedure for different tables and alter only the table in the cursor.
>
> Is there a way to alter the tabel name in a cursor?
> Is there somthing like cursor variable or cursor reference?
>

In a word, no. The cursor represents a compiled statement that
depends on the specific structure of one table.


Good luck,

Ann