I created a cursor. I did some additional processing after that cursor was created. Now there's a column I don't need anymore.
How do I get rid of that column?
I tried the following
ALTER table NameOfCursor drop column NameOfColumn
Didn't work.
Error 1115 : Invalid operation for the cursor.
Is the only solution creating another cursor and selecting only the needed columns from the original cursor?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé