posted 12 years ago
Hi Bill,
I have read the documentation, but I didn't completely understand. There is very little information in the documentation about calling stored procedure with list of objects.
But, now my problem is resolved after going though one of your links and the spring documentation together. I could not do it anyway without Oracle's ARRAY and STRUCT types.
What I have actually done is, I created STRUCT object for each set of input values and kept them in ARRAY object and passed this ARRAY object to stored procedure. Now it worked.
For anyone's reference, I am posting complete working code below.
Thanks Bill,
-Chinna