Re: Query nested table attribute of column object?

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. Received on Wed Feb 09 2000 - 08:09:12 CST