AS400 to Oracle 10g via xml with Informatica Powercenter

Question

Is the following workflow possible with Informatica Powercenter?

AS400 -> Xml(in memory) -> Oracle 10g stored procedure (pass xml as param)

Specifically, I need to take a result set eg. 100 rows. Convert those rows into a single xml document as a string in memory and then pass that as a parameter to an Oracle stored procedure that is called only once. I understood that a workflow runs row-by-row and this kind of 'batching' is not possible.

Thanks, P