hallo, i've an complex sql. it works on recordset 'testing' and also in
sql-plus. but in bindings there are not the resulting columns. i get an error
message ora00907 missing right parenthesis. what's wrong?

SELECT b.nachrichttyp,substr(a.inhalt, 5, 2) fk,sum(1) anzahl
FROM gesamt a, (select datnr,verskvnr,versname,vdatum,substr(inhalt,11,4)
nachrichttyp,to_number(znr)+1 zahl from gesamt
WHERE gesamt.ik=? and to_number(gesamt.vdatum)>=? and
to_number(gesamt.vdatum)<=? and gesamt.inhalt like 'UNH%') b where
b.zahl=to_number(a.znr) and b.datnr=a.datnr and b.verskvnr=a.verskvnr
and b.versname=a.versname and b.vdatum=a.vdatum
GROUP BY b.nachrichttyp,substr(a.inhalt, 5, 2)