Re: hierarchical query with START WITH + hierarchical subquery

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2007 07:46:48 -0700
Message-ID: <1176994008.470110.185230@p77g2000hsh.googlegroups.com>

On Apr 19, 10:38 am, Jürg Schaufelberger <juerg.schaufelber..._at_tele2.ch> wrote:
> 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

Jurg, you should have provided your exact Oracle version and platform. If your problem is due to a bug it is likely version and platform specific.

Post the query or a stripped down version that duplicates the problem along with table DDL and some data to populate the table to allow someone to try to duplicate your problem.

HTH -- Mark D Powell -- Received on Thu Apr 19 2007 - 09:46:48 CDT