Stored procedures with return code

SQL Server stored procedures can return integer values. To get the return value of a stored procedure, you must use an assignment expression in the ODBC call escape sequence:

PREPARE stmt FROM "{ ? = call proc3(?,?,?) }"