>>>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 > >I was about to post similar response. I got burned on that one myself. >Normally I never use field names longer then 10 chars. Problem was that I had one of those to be 11 - entered by mistake.
> Normally I never use field names longer then 10 chars Then this is worth looking at