PROCEDURE row_example()

BEGIN

  DECLARE category_row ROW (categoryid INT, category CHAR);

  DECLARE f CURSOR FOR SELECT Categories.CategoryId, Categories.CategoryName

                       FROM /shared/access/Categories Categories;

 

  OPEN f;

  FETCH f INTO category_row;

  CLOSE f;

END