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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

%1 does not return a result set Next Page

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


Item

Value

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.