JDBC Adapter Stored Procedure Query

[Former Member]

Hi All,

I hav a scenario where i hav to call a Stored procedure. The stored procedure returns 3 result set objects (in other words, has 3 select statements). I had configured a JDBC Sender adapter which contains the Execute statement of the Stored Procedure. When i run this scenario, i'm not getting anything displayed on the SXMB_MONI. the adapter is in green color in the Adapter monitor.Can any one help me out in this regard?

Thnx in Adv

Anil

[moorthy]

Anil,

Check these links-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Hope this helps,

Regards,

Moorthy

[Former Member]

Hi,

I am calling the Stored Procedure on the MS SQL server DB.

This SP expects a parameter and hence in the sender JDBC adapter i specifz something like this:

EXEC <stored procedure name> 'parametername'

Actually the stored procedure is returning 3 different resultsets having the same column names. have somebodz come across such a scenario. Please help!

Regards,

Anil

[moorthy]

Anil,

Did you check your Data Type is created correctly ?

And check the link, I have provided.

And first try to retrieve the 1 resultset. And check is it coming to XI.

Also check in the RWB->Message Monitoring->Select the Criteria->Audit Log.... You can check is there any error..

Just look into this also-

Hope this helps,

Regards,

Moorthy