-
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?
-
Do not use EMPTY_CLOB() function
-
I tried leaving out the Empty_CLOB() function and got the same result.
-
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.