Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query nested table attribute of column object?
bcoulam_at_my-deja.com wrote:
>
> I appreciate the feedback. Right after my last posting, my Oracle
> analyst finally did some more searching and came up with the following
> known bug:
>
> BUG 881360 PL/SQL DOES NOT SUPPORT THE UNNESTING SYNTAX WITH
> TABLE(EXPR)
>
> Unfortunately, it doesn't look like it was fixed in 8.1.6 (according the
> list of fixed bugs).
> - bill c.
>
> In article <950038310.5632.5.nnrp-09.9e984b29_at_news.demon.co.uk>,
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> >
> > I've had it on my 'to look at' list all week.
> > It's just one of those things were PL/SQL
> > has not yet caught up with SQL.
> >
> > The work around is to use the dynamic
> > sql and EXECUTE IMMEDIATE as you
> > decided for yourself.
> >
> > It's strange that Oracle Support hasn't
> > come back to you on this one, I'm sure
> > I've already seen a note about it on MetaLink.
> >
> > --
> >
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > bcoulam_at_my-deja.com wrote in message <87pcuv$ks4$1_at_nnrp1.deja.com>...
> > >This stumped you all too huh? I don't blame anyone; I'm getting the
> > >feeling a great deal of us haven't used the user-defined types much.
> > >
> > >The RevealNet PL/SQL pipeline and internal Oracle forums came up with
> no
> > >responses as well.
> > >
> > >Oracle support hasn't been able to answer my TAR either. The analyst
> > >handling the TAR emailed the PL/SQL development group. They haven't
> > >responded yet.
> > >
> > >I decided to get on with my life and implement the query in native
> > >dynamic SQL. 8i is so worth it, even if it is only to get rid of
> using
> > >dbms_sql...
> > >
> > >Best regards to anyone who actually dared to wade through the orignal
> > >posting.
> > >
> > >- bill c.
> > >
> > >
> > >Sent via Deja.com http://www.deja.com/
> > >Before you buy.
> > >
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Similar issues with CUBE and ROLLUP - fine in SQL, not so fine in PL/SQL (as at 8.1.5). See the URL below for a dynamic sql resolution to this problem.
HTH --
There are 3,434,679 oracle websites around the world. Now there is one more... http://www.oracledba.co.uk Received on Wed Feb 09 2000 - 04:29:23 CST