SAP Knowledge Base Article - Public

1205489 - Mixed or incorrect data in Crystal reports that use Oracle Long fields


In Crystal Reports, problems may arise when using more than one Oracle LONG data type field.

Some of the symptoms you might see:

  1. Mixed data between two LONG data columns when displayed within the same report.
  2. Incorrect data displayed in the column which is based on a LONG field.


Change LONG fields to CLOB fields in the Oracle table.

Oracle recommends migrating any LONG data to the CLOB type starting in Oracle 9i.

To make this change, use the TO_LOB method.

See Also

PL/SQL Character and String Types and PL/SQL LOB Types - Stanford University web site.

Converting Oracle long to lob data types - Breaking Oracle News web site.


Long CLOB Oracle Crystal Reports Datatype , 8442123 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed


SAP Crystal Reports XI ; SAP Crystal Reports XI R2