Additional languages
« 17.2.9.2 Cursor OPEN Statement
17.2.9.4 Cursor CLOSE Statement »
Section Navigation      [Toggle]

17.2.9.3. Cursor FETCH Statement

FETCH cursor_name INTO var_name [, var_name] ...

This statement fetches the next row (if a row exists) using the specified open cursor, and advances the cursor pointer.

If no more rows are available, a No Data condition occurs with SQLSTATE value 02000. To detect this condition, you can set up a handler for it. An example is shown in Section 17.2.9, “Cursors”.


User Comments

Posted by Carolyn Longfoot on February 5 2004 6:19am[Delete] [Edit]

What about cursor functions, such as @@fetch_status and @@cursor_rows in T-SQL? I don't see any such functions mentioned anywhere, and they are crucial for using cursors.

Posted by victor vatamanescu-hanga on August 5 2004 6:54am[Delete] [Edit]

Please look into DECLARE HANDLER. The NOT FOUND condition handles this particular situation.

Add your own comment.