Re: Oracle error message

amerar_at_iwc.net wrote:

> Hi all,
>
> I am trying to compile some code and I'm receiving this error:
>
> ORA-22907: Invalid CAST to a type that is not a nested table or VARRAY.
>
> What does that mean? I cannot find anything regarding this in
> conjunction with Oracle........
>
> Thanks.
>
> Arthur

It means you provided invalid information to Oracle just as you did to us.

What version of Oracle are you using? We don't know. What DDL created the table? We don't know. What DML statement did you issue? We don't know. What research did you do at tahiti.oracle.com? We don't know.

Unless you are being charged by the character to post here ... I would urge you to repost and provide enough information for someone to help you.

But to answer your question ... you are using invalid syntax.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)