Problem with Sender JDBC adapter using StoredProcedures

[chitti_prakash]

Hi All,

I am facing some prblem when i am using StoredProcedure. Please look at the error which i observe in the traces when i try to execute a stored procedure using Sender JDBC channel.

SQLException during query 'execute MAG_C0210.dbo.biz_mag_ubicaciones @data="MAG_C0210" , @idciclovida=" ", @idmaestro=" ", @idtiporeplicacion=" "':com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set

Please help me in this regard ASAP.

Cheers,

Soorya

[former_member181985]

First check the statement using SQL query analyzer.

[chitti_prakash]

Hi Praveen,

It is working fine when i executed the same in the SQL editor but when I use with XI it is failing with error

mentioned earlier. Please check this and help in solving this asap.

Regards,

Soorya