Re: Question on Hierarchy

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 20 Aug 2003 17:32:57 -0700
Message-ID: <73e20c6c.0308201632.bbc9d1a@posting.google.com>

ronnie_yours_at_yahoo.com (Ronnie) wrote in message news:<ea603f8d.0308200603.5abd5c84_at_posting.google.com>...

> Thanks a lot. The solution works when I run the query from sqlplus,
> but when i try to use the same query inside plsql it fails.

You never said anywhere that you wanted to run this inside PL/SQL. You said you wanted a query.

> Please suggest.

Upgrade to 9i. ;)

PS: you might try to generate the query as a string inside PL/SQL, then execute it as dynamic SQL?

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Wed Aug 20 2003 - 19:32:57 CDT