Hi
i am using webmethods6.5 and sql server 2005
i have made a stored procedure as testsp
which is working fine from sql server studio management
but i m getting an error as follows when i m trying to insert values using adapter service in webmethods6.5 developer
Could not run ‘testsp’.
com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service Trial:testsp.
[ADA.1.316] Cannot execute the SQL statement “{?= call test.dbo.insert_in_test_emp;1( ?, ?, ?)}”. "
(S0001/16937) A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor."
A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor.
can anyone help me out and give the solution of my problem
thank u