[% query = oracleDB.prepare('"SELECT * FROM mytable WHERE FOO = ? AND BAR = ?"') %] #... [% FOREACH vorgang = query.execute(kasse.FOO, kasse.BAR) %]