In this blog post, you’ll learn more about the Sybase Error %1 returned a result set with a different schema than expected and the reason for receiving this error
Sybase SQL Error Message
%1 returned a result set with a different schema than expected
Reason for this Error
When calling a procedure in the FROM clause of a SELECT statement, the expected schema of the result is taken from the WITH clause. If no WITH clause is given, the expected schema is taken from the system catalog. The result set returned from the call must match the expected schema or it must be possible to convert every column so that it matches.
