oracle question

Hi, I was just wondering if maybe some oracle expert can shed some light on this. I am trying to use native prepared support as much as possible in the oracle driver and I have encountered an issue with the way MDB2 is currently handling dates for oracle. Essentially all date values are wrapped in a TO_DATE() call. This has been directly taken from Metabase. I also set the following at connect: ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS' Now oracle doesnt like me using a function call for bound parameters. I may be able to get around this by sticking the actual value into the TO_DATE() call, but this gets messy as I would then have to replace the actual placeholder even if its already an oracle style ":foobar" placeholder. So the question is do I even need the TO_DATE() call if I see the NLS_DATE_FORMAT? The other issue I am currently running into is that it seems I probably have to parse all prepared queries and split them up anyways in order to get LOB support working, since there I need to replace the placeholders with EMPTY_BLOB()/EMPTY_CLOB(). regards, Lukas