I am trying to pass one IN parameter from my stored procedure in webMethods which is of user defined type ‘VARRAY’. (Varray of varchars) What JDBC type and Input type should be selected from store proc so that it will get type casted to my varray type.
When I am initializing this IN parameter in expression as Varray_Type(‘123’,‘456’) keeping the JDBC type as varchar and input type as java.lang.string, this proc works fine.
Passing the same expression at run time, it doesn’t work.
How this varray can be passed from webMethods stored proc?