Using CLOBS in Crystal

[hauxe]

I can't locate much info on whether or not CLOBS are supported in Crystal 8. (CLOBS are character large objects in Oracle).

When I try to reference one I receive an "inconsistent datatype" error.

Anyone know whether or not you can successfully access the contents of a CLOB?

 

[Naith]

Character Large OBjects are treated exactly the same way as Binary Large OBjects.

You're most likely just connecting to the database with an inappropriate driver. You'll probably find that you can't report on BLOBs either - and BLOBs are supported in Crystal.

Try switching your driver to CROR8 (or CROracle8) instead of the Oracle driver.

Naith