FETCH_STATUS

Returns the status of the last FETCH statement in a stored procedure, user defined function or trigger.

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.