To enable the use of CLOBs for product descriptions you need to modify the type of the "products_description" column in the "products_descriptions" table and set the "FETCH_PRODUCT_DESCRIPTIONS_SEPARATELY" configuration variable to "true". For convenience a little SQL script called database/Oracle/UseCLOBForProductDescriptions.sql is provided for this purpose.

The "Fetch Descriptions Separately" configuration variable can also be set in the Admin App.

In most situations you should leave this configuration variable set to "false" for better performance. The purpose is to modify the way product descriptions are retrieved from the database. If this is set to "true" the product descriptions are retrieved separately after the main product queries have been completed. This is required when using databases where the type of the products_description column has been changed from the KonaKart default value (for example to CLOB in Oracle) which cannot be used as part of the standard KonaKart product queries.