E CURSOR c IS SELECT value FROM $table_name WHERE key = :name; BEGIN OPEN c; WHILE 1 = 1 LOOP FETCH c INTO my_func(); IF c % NOTFOUND THEN EXIT; END IF; END LOOP; CLOSE c;