Updating clob data
ARS system is designed to handle the change in the structure.This document provides information about converting TC to CLOBS.Fetching data from LONG CHARACTER or DIARY Field created in ARS 4.5 or later. API ARGet List Entry call will allocate memory equal to the size of data content in the field.Then 10K memory allocation is done to read the data.Information about the conversion process from TC to CLOB fields C within T table is given in given below.5.The context is Upgrade of ARS from 4.0.3 (or earlier) to 4.5 (or later) on top of Oracle database.ARS System should be stopped when executing this procedure.
In ARS 4.0.3 separate table is created for each of the LONG CHAR and DIARY fields in an ARS Form. In ARS 4.5 LONG CHAR and DIARY fields are stored as CLOBS.
If this malloc fails (because OS is not able to give 500000 bytes of contiguous memory for whatever reason) then ARS will not be able to get remaining data for this field from the Oracle Server.