Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> owa_pattern.pattern as a type

owa_pattern.pattern as a type

From: Mike Reed <news_at_amadron.com>
Date: Tue, 20 Dec 2005 13:13:28 GMT
Message-Id: <pan.2005.12.20.13.12.28.347610@amadron.com>


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> Received on Tue Dec 20 2005 - 07:13:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US