CREATE OR REPLACE PROCEDURE test
AS
DECLARE
    CURSOR get_test IS
        SELECT t_testen
        FROM TABLE;
BEGIN
    FOR i IN get_test
        LOOP
            IF <condition>
            END IF;
        END LOOP;
END;