In this blog post, you’ll learn more about the Sybase Error Use of %TYPE or %ROWTYPE is not allowed for variable or temporary objects. and the reason for receiving this error
Sybase SQL Error Message
Use of %TYPE or %ROWTYPE is not allowed for variable or temporary objects.
Reason for this Error
You tried to use %TYPE or %ROWTYPE with a temporary object such as procedure parameters or a result set, which is not allowed.