Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> hierarchical query with START WITH + hierarchical subquery

hierarchical query with START WITH + hierarchical subquery

From: Jürg Schaufelberger <juerg.schaufelberger_at_tele2.ch>
Date: 19 Apr 2007 07:38:23 -0700
Message-ID: <1176993503.304582.172740@b75g2000hsg.googlegroups.com>


Hello

I try to run a hierachical query A on a Oracle 9i server. The start with clause is a hierarchical subquery B. If I run the subquery B standalone, I get the expected result. But if I run the query A I get the error ORA-03113.

If I replace the subquery B expression with its resultlist, the modified query A runs without error. Any idea ? Thanks for help.

Jürg Received on Thu Apr 19 2007 - 09:38:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US