Oracle has a slightly differnt syntax for CTEs require arguments, keyword "recursive" is not allowed. This fixes the following error during initial installation:
nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00905: missing keyword
SQL: with recursive !>>>!object_hierarchy as ( select object_type, supertype from acs_object_types where object_type = coalesce(:object_type, (select object_type from acs_objects where object_id = :object_id))
union all
select t.object_type, t.supertype from acs_object_types t, object_hierarchy s where t.object_type = s.supertype ) select distinct callback, callback_type as type from subsite_callbacks where event_type = :event_type and object_type in (select object_type from object_hierarchy)