var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: oracle 7 clob
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.
Oracle did not provide LOB support til Oracle 8.0
There is nothing in Oracle7 that enables LOB support.