Re: Oracle Question!!

I cannot get clobs to work with Oracle 8.05 (for NT) either.

If I use the Enterprise SQL Worksheet tool and:

CREATE TABLE table1 (Test1 clob, test2 clob);

Then I can:

INSERT INTO table1 VALUES ('Test text', 'More text');

The insert works. But I cannot:

SELECT * FROM table1;

or

SELECT test1 FROM table1;

It returns an error 'inconsistent datatypes' in both cases.

Any ideas what's wrong?

Guy Pardoe
Pardoe Development Corporation Received on Wed Jun 02 1999 - 05:34:54 CDT