Select CLOB from table

[AlexR]

How can I run a select statement to read a column of (CLOB) from Oracle. Right now I get this error from Oracle ORA-03115 Unsupported network datatype or representation. The select statement worked fine until some changes were made to the table and a field of VARCHAR2(1000) was changed to a CLOB. I am trying to run a simple select statement on a few fields and one of them is of the type CLOB. So select a, b, c from expTable won't work if c = CLOB. How can i run this statement to get this to work. Thanks for the help.

 

[Turkbear]

Hi,
IIRC, CLOBs need special handling, check out the docs for
DBMS_LOB package to see what's needed..

 

[sem]

Try to use more recent sql*plus (8.0 and above)

 

[AlexR]

Can you tell me how to do this with SQL plus

 

[sem]

Use an ordinary SELECT statement. If you feel the data is truncated, increase LONG value by

SET LONG 100000