Data type mismatch error

[former_member586747]

Hi,

Please advice to fix below error.

I am trying execute stored procedure which will insert data into a table 'MBEW_NEW' from table 'MBEW' with filtered data. I have created MBEW_NEW table with similar data types like MBEW. While I am trying to execute the procedure, decimal data type fields giving me below error.

Could not execute 'call "SP_TEST"."MBEW_PROC"()' in 4.150 seconds .

SAP DBTech JDBC: [6]: invalid data:  [6] "SP_TEST"."MBEW_PROC": line 5 col 1 (at pos 73): [6] (range 3): invalid data: setITab failed: copyColumnData() failed: attribute 'VERPR' from source type='string' into target attribute 'VERPR' with type='fixed9.2' for table 'SP_TEST:MBEW1'

Please share your thoughts to fix above issue.

Thanks in advance.

dev

[former_member586747]

This issue has fixed. Thanks all.

[former_member226419]

Pls provide your code

[Former Member]

The error indicates that you are mapping columns with incompatible data types. Due to a lack of information I can't provide any more targeted advice. Usually it is optimal to use identical data types on source and target side.