FETCH_STATUS

Returns the status of the last FETCH statement in a stored procedure.

Syntax

FETCH_STATUS()

Description

Returns the status of the last FETCH statement issued against a cursor.

Return Value Description

0

The FETCH statement was successful.

-1

The FETCH statement failed or the FETCH is fetching past the last row of the returned result set.

Parameters

None.