Mike Reed wrote:
> Hi,
> Why can't I use owa_pattern.pattern as a column type?
>
> SQL> create table temp(
> 2 names owa_pattern.pattern
> 3 ) nested table names store as temp_names;
> names owa_pattern.pattern
> *
> ERROR at line 2:
> ORA-00902: invalid datatype
>
>
> SQL>

I don't think you can create a table based on a PLSQL type. It has to
be an object type:-

create or replace type pattern as object ( p1 varchar2(4) );
/

create or replace type pattern_a as table of pattern;
/

create table test_pat ( names pattern_a ) nested table names store as
names;

That works!