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

Passing Array as Input Stored Procedure

  • 1.  Passing Array as Input Stored Procedure

    Posted Tue May 08, 2007 12:51 PM

    Hi

    Development env : 6.5

We need to make a stored procedure call , having two  IN parameters

    one is a Varchar type other is VARRAY . So how do we specify array(String LIst)
    as input to this procedure in wM . Can it be done using the available Stored procedure templates ?

    Thanks.


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


  • 2.  RE: Passing Array as Input Stored Procedure

    Posted Tue May 08, 2007 01:23 PM

    Hi Archana,

    Currently the only way to pass the input to java.sql.Array is " to fire a Select query on some temporary table, that return java.sql.Array object and then map it to stored procedure service input. " which might really not make sense in all the scenarios. But there is no other way to do inbound Array mapping.

    Thank you


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


Related Content