Re: Query nested table attribute of column object?

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.
>
Received on Tue Feb 08 2000 - 13:29:09 CST