>>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#
1459597I 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.