CLOB columns being created as Undefined
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: CLOB columns being created as Undefined

  1. #1
    Join Date
    Feb 2002
    Posts
    2
    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?

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    Do not use EMPTY_CLOB() function
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Feb 2002
    Posts
    2
    I tried leaving out the Empty_CLOB() function and got the same result.

  4. #4
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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
  •  


Click Here to Expand Forum to Full Width