View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 09:21 AM
Mike Reed
 
Posts: n/a
Default owa_pattern.pattern as a type

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>
Reply With Quote