Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (special characters)

 

%1 returned a result set with a different schema than expected

Error constant SQLE_BAD_RESULT_SET
ODBC 2 State ERROR
ODBC 3 State ERROR
Parameter 1 Name of the procedure that returned the incorrect result set.
Severity 12
SQLCODE –866
SQLSTATE WP012
Sybase error code 13870
Probable cause

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.