This discussion is archived
0 Replies Latest reply: Aug 26, 2012 11:23 PM by 958107 RSS

Get error when CONNECT BY PRIOR used by where

958107 Newbie
Currently Being Moderated
Hi
I get "No more data to read from socket" error when the result of CONNECT BY PRIOR used after where, is there anybody encounter this error?
example SQL:
select
from table_A
where exists
(select 1 from table_b
START WITH table_b.col1 = 'value'
CONNECT BY PRIOR table_b.col1 = table_b.col2)

The sql select 1 from table_b START WITH table_b.col1 = 'value' CONNECT BY PRIOR table_b.col1 = table_b.col2 can return 2 row correct, but the whole sql does not work.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points