Dropping global temporary tablesMike,
I don't have a solution for the error, but here is one for the JOIN on a
CONNECT BY. Push the CONNECT BY query to an inline query. Here's an example

SELECT e.e_level,
e.ename,
e.empno,
e.mgr,
d.dname
FROM dept d,
(SELECT level e_level,
LPAD(' ',2*level-2)||emp.ename ename,
emp.empno empno,
emp.mgr mgr,
emp.deptno deptno
FROM Emp
CONNECT BY PRIOR emp.empno = emp.mgr
START WITH emp.mgr IS NULL) e
WHERE e.deptno = d.deptno;


Oracle LazyDBA home page