WHILE 1 = 1 LOOP FETCH idx INTO iid; IF (SQL % NOTFOUND) THEN EXIT; END IF; DELETE FROM SYS_FIELDS WHERE INDEX_ID=iid; DELETE FROM SYS_INDEXES WHERE CURRENT OF idx; END LOOP; CLOSE idx; END LOOP; CLOSE tab; END;