0 Replies Latest reply: Jan 8, 2015 1:15 PM by 958107 RSS

    Get error when CONNECT BY PRIOR used by where

    958107

      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.