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
Back to discussions
Expand all | Collapse all

Getting error when executing storedProcedurewithSignature Adapter service.

  • 1.  Getting error when executing storedProcedurewithSignature Adapter service.

    Posted Sat March 28, 2015 11:41 AM

    Created a storedProcedure which returns xml output as CLOB Object and able to successfully compiled. When running the adapter service getting below error msg:

    [ADA.1.316] Cannot execute the SQL statement “{call WM82.EMP_PROC( ?)}”. "
    (42000/932) ORA-00932: inconsistent datatypes: expected - got -
    ORA-06512: at “WM82.EMP_PROC”, line 7
    ORA-06512: at line 1
    "
    ORA-00932: inconsistent datatypes: expected - got -
    ORA-06512: at “WM82.EMP_PROC”, line 7
    ORA-06512: at line 1

    Did anyone get a chance to call storedProcedurewithSignature which is having output of type CLOB … Kindly through some light to resolve
    storProcCall.JPG


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


Related Content