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