Sonic ESB Database Service - how to call store procedure wit

Hi,

I am using Sonic ESB 8.0.1 and was wondering if someone can tell how to call store procedure (oracle) which takes in Oracle object as input. For example - how to do something similar:

callableStatement.registerOutParameter(1, Types.STRUCT, "HIE"."ACTIVEPARTICIPANT_OBJ")

callableStatement.registerOutParameter(2, Types.ARRAY, "HIE"."CODEDVALUETYPE_TAB");

The template for DB service does not give an option to add STRUCT/ARRAY - is there a way for which this can be done for IN parameter.

thanks a lot.

-rajneesh

Message was edited by: Rajneesh Kapur