Re: owa_pattern.pattern as a type

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! Received on Tue Dec 20 2005 - 08:27:35 CST