After running openacs on 10G i noticed that
fullquery name="relation_types_valid_to_group_multirow.select_sub_rel_types"
select
pretty_name, object_type, level, indent,
case when valid_types.rel_type = null then 0 else 1 end as valid_p
from
(select
t.pretty_name, t.object_type, level,
replace(lpad(' ', (level - 1) * 4),
' ', ' ') as indent,
rownum as tree_rownum
from
acs_object_types t
connect by
prior t.object_type = t.supertype
start with
t.object_type = :start_with ) types,
(select
rel_type
from
rc_valid_rel_types
where
group_id = :group_id ) valid_types
where
types.object_type = valid_types.rel_type(+)
order by tree_rownum
Give me always the following error:
ORA-01788: CONNECT BY clause required in this query block
SQL:
select
pretty_name, object_type, level, indent,
case when valid_types.rel_type = null then 0 else 1 end as valid_p
from
(select
t.pretty_name, t.object_type, level,
replace(lpad(' ', (level - 1) * 4),
' ', ' ') as indent,
rownum as tree_rownum
from !>>>! acs_object_types t
connect by
prior t.object_type = t.supertype
start with
t.object_type = :start_with ) types,
I face this when i try to add a member to a group
Any Ideas?