webMethods

webMethods

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

Unable to invoke the Stored Procedure call

  • 1.  Unable to invoke the Stored Procedure call

    Posted Mon September 12, 2005 06:14 AM

    Hi,

       I am facing the following error when i try to run the update stored procedure call.I am using webMethods6.1.

    com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service UL.OMPCS.OMPCS.OMOutbound.DBServ:callAttribute1UsingPartySiteId.
    [ADA.1.316] Cannot execute the SQL statement “{call APPS.XXUL_UPDATE_ORDER_LINES.get_attribute1 (?) }”. "
    (65000/6550) ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to ‘GET_ATTRIBUTE1’
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored
    "
    ORA-06550: line 1, column 7:
    PLS-00306: wrong number or types of arguments in call to ‘GET_ATTRIBUTE1’
    ORA-06550: line 1, column 7:
    PL/SQL: Statement ignored


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 2.  RE: Unable to invoke the Stored Procedure call

    Posted Mon September 12, 2005 03:50 PM

    The procedure or function you are attempting to invoke accepts a different number of parameters or accepts parameters with different data types that what you are passing.

    Are you using the stored procedure with signature adapter service template?

    Mark


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


Related Content