On Wed, Sep 23, 2009 at 3:53 PM, Daniel Bradley <daniel.brad...@adfero.co.uk
> wrote:
> After investigating the log files, the DataImporter was throwing an error
> from the Oracle DB driver:
>
> java.sql.SQLException: ORA-22835: Buffer too small for CLOB to CHAR or BLOB
> to RAW conversion (actual: 2890, maximum: 2000)
>
> Aka. There was a problem with the 551st item where a related item had a
> text field of type Clob that was too long and was therefore causing a
> problem when using the function TO_NCHAR to fix the type.
>
> FIX:
> Used the Oracle function dbms_lob.substr("FIELD_NAME", MAX_LENGTH, 1) to
> just trim the string (this also applies and implicit converstion).
>
>
Phew, tricky one! Thanks for bringing closure.
--
Regards,
Shalin Shekhar Mangar.
