Oracle field length error after Oracle patch update

[Former Member]

Dear All,

We have an ABAP program wherein we are inserting records in an external (non-SAP) Oracle DB

by means of native SQL. On 22/08/2010, we had updated an Oracle patch in the production server.

After the patch was updated, the program has started throwing error:

An SQL error has occurred: ORA-12899: value too

large for column

"CELLAPPS"."AWLTBLMESSAGES"."MESSAGETEXT" (actual:

438, maximum: 350)#ORA-06512: at line 1

The message text variable has only 219 characters. After some observations, i found that all the data is

converted into exactly double the length after this oracle patch update.

Please help.

Thanks.

[Former Member]

closed with the help of SAP support

[dominik_kramer]

We have the same problem...

It would be helpful to know what the SAP did to solve the problem....

[former_member184473]

Hello,

Which is your NLS for your SAP and the external databases?

SELECT VALUE FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

What is your DBCO Conn. Info field?

What is the result if you set the remote connection in DBCO as per SAP note [808505|http://service.sap.com/sap/support/notes/808505]?

Regards,

Eduardo Rezende

[Former Member]

More information needed.

Which Oracle patch? What is old and new release? For example 10.2.0.2 -> 10.2.0.4 ? Or an interim patch?

And it is not quite clear which database you patched, what do you call the production server, the SAP database, or the external database?