jump to navigation

Data type and length of field in DB system ORA have been changed January 27, 2012

Posted by Ajay in SAP BW.
add a comment

SAP BW error : Data type and length of field ‘XXXX’ in DB system ‘XXXXXXX ORA have been changed.

The ods is getting data from Oracle.

I found out that data type for the column has been changed in oracle from varchar2(120 byte) to varchar2(120 char).

change the column in Oracle : CAST(USER_filed AS VARCHAR2(120)) .

Now data load is successful.

Advertisements