Thank you.

As advised in Oracle Cursors Exceeded, I changed my code to use a prepared query and placeholders. I changed my code to:

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

But then I get

undef error - Bad hash at C:/Perl/site/lib/Template/Plugin/DBI.pm line
+ 366.
[download]

:(

As you may have spotted, there is a stupid copy & paste typo in the code above (2 quote marks). This is corrected now and the program runs like a charm. Thanks again for the hint. :))

The correct code:

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