[%
  USE oracleDB = DBI
  (
    "dbi:Oracle:SOMEDB", "someuser", "somepassword"
  )
-%]

<vdx_data>

[%- FOREACH kasse = oracleDB.query( 'SELECT DISTINCT foo, bar FROM mytable ORDER BY foo, bar' ) %]
  
  <vknr V="[% kasse.FOO %]">
      <zp_kv V="[% kasse.BAR %]"/>
  </vknr>
            
  <vorgang_liste>
  [%- FOREACH vorgang = oracleDB.query( "SELECT * FROM mytable WHERE FOO = $kasse.FOO AND BAR = $kasse.BAR" ) %]

    <vorgang>
        <vdx_abrechnungsbereich V="[% vorgang.ABC %]"/>
        <gkv_konto V="[% vorgang.DEF %]"/>
    </vorgang>

  [%- END %]
  </vorgang_liste>

[%- END %]
</vdx_data>

##</code><code>##

DBI error - DBI prepare failed: ORA-01000: maximum open cursors exceeded (DBD ERROR: OCIStmtExecute/Describe)