JDBC adaptor service throwing an error while calling stored procedure

Hi All,

I am getting the below error when an adapter service calls a stored procedure.
I can run all other sql statements select, insert and update without any issues.

com.wm.pkg.art.error.DetailedServiceException:[ART.117.4002}Adapter Runtime(Adapter Service): Unable to invoke adapter service TEST.adapters:wm_test [ART.114.505 ] Error while invoking adapter service com.wm.adapter.emjdbc.services.StoredProcedure.null at com.wm.pkg.art.error.DetaileServiceException.create

Database used : SQL server 2000.
webMethods server : 6.5 with SP1

Also placed the three jar files and restarted the server.

Still seeing the same issue.

Please help me.


Check if you can execute strored proc directly from passing input directly. If it is giving proper results ?