CLOB columns being created as Undefined

[someguy]

I'm running Oracle 8.1.7 on NT

I'm using the following statement to create a CLOB column:

create table worklog (request_id varchar2(15), worklog CLOB default EMPTY_CLOB())

but instead of creating the column as a CLOB, it is showing up as UNDEFINED. The undefined column will not allow any manipulation.

Has anyone ever had this problem?

[kgb]

Do not use EMPTY_CLOB() function

[someguy]

I tried leaving out the Empty_CLOB() function and got the same result.

[kgb]

Sound starnge, it works on my machine.
try to rename CLOB column as table and column has the same name, may be your Oracle does not like it.