In this blog post, you’ll learn more about the Sybase Error Unable to declare a row variable from the cursor using %ROWTYPE; invalid name for field %1. and the reason for receiving this error
Sybase SQL Error Message
Unable to declare a row variable from the cursor using %ROWTYPE; invalid name for field %1.
Reason for this Error
The field name used to declare a row type using cursor %ROWTYPE is not defined or is invalid. Use a SELECT list alias in the query specification or specify the result set in the procedure definition.