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

  • 1.  Stored procedure with Array as input

    Posted Thu August 04, 2016 08:15 PM

    Hi Everyone,

    I have an issue passing string list as an input to the adapter service template storedprocedure with signature.
    Does webMethods supports passing array as input to the “storedprocedure with signature” adapter service by directly calling it to flowservice ?
    If anyone implemented the same case, please guide me with the same ?


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


  • 2.  RE: Stored procedure with Array as input

    Posted Fri August 05, 2016 03:35 AM

    Hello,

    Did you see any errors, if yes, please share those along with screen shots. Also which wM version, JDBC adapter you are using, fix levels ?

    Thanks,


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


  • 3.  RE: Stored procedure with Array as input

    Posted Thu August 11, 2016 05:32 PM

    Sorry for the late reply…

    We have to pass input as STRUCT type to call SP

    com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service
    [ADA.1.316] Cannot execute the SQL statement “call
    SCHEMA.PKG.P_NUMS( ?, ?)”. "
    (99999/17074) invalid name pattern: SCHEMA.PKG"
    invalid name pattern: SCHEMA.PKG

    wM version 9.8
    JDBC Adapter version 9.0
    JDBC Fix- JDBC_9.0_Fix7
    IS fixes: IS_9.8_Core_Pre-QAFix_PIE-40509_v2
    IS_9.8_SPM_Fix1
    IS_9.8_Core_Fix5

    Attached the screen shots of adapter service. Sorry, I had to erase and hide few names in the screen shot.

    SP.jpghttps://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/cc32acce5b67d36f283c55b5adedc914be891947_2_1035x474.jpeg 1.5x, https://higherlogicdownload.s3.amazonaws.com/IMWUC/webMethods/Files3/cc32acce5b67d36f283c55b5adedc914be891947_2_1380x632.jpeg 2x" data-dominant-color="FDFDFD">
    SP.jpg2494×1144 198 KB


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


  • 4.  RE: Stored procedure with Array as input

    Posted Fri August 12, 2016 08:20 AM

    Hi Kritaa,

    what does SCHEMA stand for?

    Did you try using “” (the schema belonging to the user used to login to the database)?

    Regards,
    Holger


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


  • 5.  RE: Stored procedure with Array as input

    Posted Fri August 12, 2016 11:16 AM

    Hi Holger,

    Actual schema name is different. Not to disclose the actual name,I mentioned it has SCHEMA.
    Yes the schema is the user used to login the DB.

    Thanks


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


  • 6.  RE: Stored procedure with Array as input

    Posted Fri August 12, 2016 01:27 PM

    Hi Kritaa,

    then I am wondering why not just using “” option for schema.

    Is the srored procedure correctly created on database and valid?

    What is your Oracel version, btw?

    Eventually it might be worth to try JDBC_9.0_Fix9.
    Additionally you should check for WAR_9.8_Fix2 (for the AdapterRunTime).

    Regards,
    Holger


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


Related Content