>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?


The reason why you cannot is : the cursor contains a field with a name longer than 10 chars

See message#1459597