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