[RESOLVED] Problem with CURSOR FETCH

[mrbaseball34]

I am declaring a cursor like this:

DECLARE cur_product_import CURSOR FOR
  SELECT active_item, part_number, sup_part_number, title, image,
         manufacturer, short_description, long_description, cost,
         list, isn_retail, mapp, category, subcategory, shipweight,
         length, width, height, stocking, reorder, uom, freight_item,
         hazmat, carb, ormd, self_contained, warranty, date_added,
         modifiy_date, qty_on_hand, upc, for_future_use_1,
         for_future_use_2, for_future_use_3, for_future_use_4,
         for_future_use_5, for_future_use_6, for_future_use_7
  FROM product_import;

For some reason, my fetch is not actually fetching anything:
(ALL variables are declared!)

REPEAT
  FETCH cur_product_import INTO
    active_item, part_number, sup_part_number, title,
    image, manufacturer, short_description, long_description,
    cost, list_, isn_retail, mapp, category, subcategory,
    shipweight, length_, width, height, stocking, reorder,
    uom, freight_item, hazmat, carb, ormd, self_contained,
    warranty, date_added, modify_date, qty_on_hand, upc,
    for_future_use_1, for_future_use_2, for_future_use_3,
    for_future_use_4, for_future_use_5, for_future_use_6,
    for_future_use_7;

All values are being returned as NULL and the repeat doesn't actually iterate through the cursor.

Any ideas??? Do the variables have to have different names than the columns in the cursor?

[mrbaseball34]

Had unclosed control structures. sigh!