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 ?
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.