oracle8.1.6 select CASE WHEN (to_date(:start_date,:date_format) - to_date(:end_date,:date_format)) <= 0 THEN 1 ELSE -1 END from dual select cal_items.cal_item_id, 0 as n_attachments, to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, nvl(e.name, a.name) as name, nvl(e.description, a.description) as description, recurrence_id, cal_items.item_type_id, cal_item_types.type as item_type, on_which_calendar as calendar_id, c.calendar_name, o.creation_user from acs_activities a, acs_events e, timespans s, time_intervals t, cal_items, cal_item_types, calendars c, acs_objects o where e.timespan_id = s.timespan_id and s.interval_id = t.interval_id and e.activity_id = a.activity_id and e.event_id = :cal_item_id and cal_items.cal_item_id= :cal_item_id and cal_item_types.item_type_id(+)= cal_items.item_type_id and c.calendar_id = on_which_calendar and o.object_id = cal_items.cal_item_id select cal_items.cal_item_id, (select count(*) from attachments where object_id = cal_item_id) as n_attachments, to_char(start_date, 'YYYY-MM-DD HH24:MI:SS') as start_date_ansi, to_char(end_date, 'YYYY-MM-DD HH24:MI:SS') as end_date_ansi, nvl(e.name, a.name) as name, nvl(e.description, a.description) as description, recurrence_id, cal_items.item_type_id, cal_item_types.type as item_type, on_which_calendar as calendar_id, c.calendar_name, o.creation_user from acs_activities a, acs_events e, timespans s, time_intervals t, cal_items, cal_item_types, calendars c, acs_objects o where e.timespan_id = s.timespan_id and s.interval_id = t.interval_id and e.activity_id = a.activity_id and e.event_id = :cal_item_id and cal_items.cal_item_id= :cal_item_id and cal_item_types.item_type_id(+)= cal_items.item_type_id and c.calendar_id = on_which_calendar and o.object_id = cal_items.cal_item_id begin :1 := recurrence.new(interval_type => :interval_type, every_nth_interval => :every_n, days_of_week => :days_of_week, recur_until => :recur_until); end; begin acs_event.insert_instances(event_id => :cal_item_id); end;