I created a table in which one of the fields was of CLOB datatype.
When I run select statements from SQL prompt the table is accessible for me. However, when the developer tries in her application to access the table it comes up with an error . The same statements which run perfectly do not run in the Oracle ODBC Test environment.
I tried changing the CLOB field to a varchar2 and the whole thing works.
What is to be done for using the table with CLOB datatype?Putting that field in another tablespace- will that help?
thanks
manjunath