Skip to Content
author's profile photo Former Member
0
Former Member
Jul 17, 2008 at 05:07 AM

MS SQL Server Stored Procedure - JDBC Receiver Adapter

432 Views

Hi,

I am calling a stored procedure in MS SQL Server using the JDBC Receiver Adapter. The stored procedure takes 1 input parameter which is a VARCHAR field. The stored procedure's input parameter and the input parameter are identical. My target structure looks like:-

<STATEMENT>

<storedProcedureName action="EXECUTE">

<TABLE>SP_REPROCESS</TABLE>

<input1 isInput="true" type="VARCHAR">1</input1>

</storedProcedureName>

</STATEMENT>

I am getting the following error:-

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SP_REPROCESS' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

Any suggestions.

Thanks.

Krishnan

Edited by: Krishnan on Jul 17, 2008 7:07 AM

Edited by: Krishnan on Jul 17, 2008 7:07 AM

Edited by: Krishnan on Jul 17, 2008 7:48 AM