Results 1 to 2 of 2

Thread: oracle 7 clob

  1. #1
    Join Date
    Jun 2004
    Posts
    1

    Unanswered: oracle 7 clob

    Hello

    I am trying to create a clob column in an Oracle 7 database. I was led to believe that Oracle 7 supported clobs (which I intend to use to store xml documents).

    my code is equivalent to

    CREATE TABLE test_tab
    ( col_id number(10) primary key,
    col_text clob not null) ;

    however when I execute this I obtain an error

    col_text clob not null)
    *
    ERROR at line 3:
    ORA-00902: invalid datatype

    Do I need to switch on clob support in Oracle 7 or is my code wrong?

    Sorry I am no dba and my oracle experience until now has been with versions 8 and 9.
    regards

    Stephen

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Oracle did not provide LOB support til Oracle 8.0

    There is nothing in Oracle7 that enables LOB support.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •