Re: cannot have subqueries in CONNECT BY clause

There are (sketchy):

create table classify(
cid type1,
cmaster type1,
CONSTRAINT pk_classify PRIMARY KEY(cid) using index tablespace budget_index, CONSTRAINT fk_classify_master FOREIGN KEY(cmaster) REFERENCES classify
) tablespace budget_data;

create table classifyRW (
cid,
username type2,
CONSTRAINT pk_classifyRW PRIMARY KEY(cid,username) using index tablespace budget_index,
CONSTRAINT fk_classifyRW_classify FOREIGN KEY(cid) REFERENCES classify ON DELETE CASCADE
) tablespace budget_data;

create or replace view classify_rview as select cid,cmaster from classify f
where exists(select null from classifyrw where cid=f.cid and username=user);

And 'ORA-01473: cannot have subqueries in CONNECT BY clause' appears when

select * from classify_rview start with cmaster is null connect by prior cid=master;

is run; Received on Mon Nov 19 2001 - 03:55:52 CST