-
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
Best wishes!
Dmitri
-
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.
Best wishes!
Dmitri
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|