Coltype Undefined

Hi

What the hell is happening???
Here 's what I do on an Oracle9.2 Database running Win2k

create table Name ( one timestamp )
select name, coltype, length from syscolumns where tbname = 'NAME'

this is what i get:

NAME                           COLTYPE       LENGTH
------------------------------ --------- ----------
ONE                            UNDEFINED         11

How is that possible??
What can I do???

Marc Received on Thu Dec 19 2002 - 03:35:59 CST