Passing Array as Input Stored Procedure


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 ?


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