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.

 View Only
Expand all | Collapse all

Stored procedure without signature is not working

  • 1.  Stored procedure without signature is not working

    Posted Thu October 22, 2020 02:45 PM

    Hi all,
    Im using stored procedure without signature .this procedure updates some records in db.i need to pass one input to this procedure which is numeric type is that procedure.so while passing the input from wM

    which one shoud i select should i use NUMERIC or should i use DECIMAL.


    #webMethods


  • 2.  RE: Stored procedure without signature is not working

    Posted Tue October 27, 2020 12:17 PM

    I would go with NUMERIC unless the data needs DECIMAL to be selected.

    We need to ensure SP inputs SQL data types and Input Types we select are in sync and appropriate.


    #webMethods