Devart Forums

Hello everybody,

I have some problems with CLOBs and ODAC.

First of all, until last week we used the BDE components (TDatabase and TQuery), there CLOBs worked fine.

Now we switched over to ODAC (TOraSession and TOraQuery), but every time we want to execute a SQL that returns a CLOB (or BLOB), we receive the message "Data Type not supported".

Do you have an idea why it does not work?
The Net-option of the TOraSession is set to false.


SQL: "SELECT SQL_FULLTEXT FROM V$SQLAREA"
Database: Oracle 10i Enterprise 10.2.0.4.0 - 64bit
Client: Oracle 10.2.0.
BCB 6.0
ODAC 5.70.0.30 (I know, not really up-to-date)


Best regards from germany.

We could not reproduce the problem. Please send to odac*devart*com a complete small sample that demonstrates the problem.

No problem, sample has been sent.

Problem has been solved - the Option "UseOCI7" was set to true. After switching it over to false, it works.

Thank you for your help!