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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Error Creating Stored Procedure w/Signature

  • 1.  Error Creating Stored Procedure w/Signature

    Posted Wed January 14, 2009 03:09 PM

    Hi,

    A few week back the IS started to show the following error when creating an Adapter service - Stored Procedure With Signature.

    com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
    [ADA.1.320] Cannot get the list of stored procedures. "
    (17412) Bigger type length than Maximum"
    Bigger type length than Maximum
    on procedureSignature.colIndexes [Ljava.lang.String;@170376


    Note that I’m able to select the Procedure Name in the combo box, but once selected the error is display.

    Thanks.
    Francisco Pereira

    Any ideas why?


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


  • 2.  RE: Error Creating Stored Procedure w/Signature

    Posted Wed February 04, 2009 11:30 PM

    What version of the JDBC adapter is this? Do you have latest version of the JDBC drivers installed?


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


  • 3.  RE: Error Creating Stored Procedure w/Signature

    Posted Thu February 12, 2009 08:05 PM

    I change my driver to ojdbc14.jar and ocrs12.zip, and it started working correctly.

    Those are the jars recommended for my Oracle DB Version.

    Thanks


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


Related Content