Error 866

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

Item Description

SQLCode

-866L

Constant

BAD_RESULT_SET

SQLState

WP012

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2516

Severity Code

12

Parameter 1

Name of the procedure that returned the incorrect result set.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com