IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Back to discussions
Expand all | Collapse all

Unable to run stored procedure from sql server

  • 1.  Unable to run stored procedure from sql server

    Posted 09/16/08 03:01 PM

    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


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


Related Content