CLOB: Data type not supported

Agamemnon · Post by **Agamemnon** » Fri 31 Jul 2009 12:09

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.

Plash · Post by **Plash** » Thu 06 Aug 2009 08:02

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

Agamemnon · Post by **Agamemnon** » Wed 26 Aug 2009 06:39

No problem, sample has been sent.

Agamemnon · Post by **Agamemnon** » Fri 28 Aug 2009 08:24

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

Thank you for your help!