Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

How to run Stored Procedure with Parameters

Developers
T K
2010-09-30
2012-12-10
  • T K
    T K
    2010-09-30

    I cannot execute any stored procedure with parameters . I used database_statement as the jobtype and type in the following as command  dbo.setSomething USA, 1; commit;

    The warning I get is :

    2010-09-24 14:45:56.672    error occurred processing managed order  : java.lang.Exception: java.lang.Exception: sos.connection.SOSConnection.executeStatements(2943) : java.lang.Exception: sos.connection.SOSConnection.executeUpdate(1925):com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update 

    Have anyone seen similar errors? Any help is appreciated.