select distinct eventSchedule from EventSchedule
as eventSchedule left join eventSchedule.offeringList
as offering left join eventSchedule.guideTheatreList as
guideTheatre join offering.program as program where guideTheatre.theatre
in (2) and eventSchedule.startDatetime >= TO_DATE('23-May-2005 20:53','DD-MON-YYYY HH24:MI')
and eventSchedule.endDatetime <= TO_DATE('10-Jul-2005 20:53','DD-MON-YYYY HH24:MI')
order by eventSchedule.startDatetime

the above works great with thin drivers and gives 00933 Error when i used OCI any idea?

Regards
Sudhir