Pinned topic Processing Ref Cursor Output
Next, we use a simple flat-file schema that contains a repeating list of row elements that will be separated by end-of-line characters (defined at the root level of the flat-file schema). This will produce a file like this:
Where data is the rows extracted from the Ref Cursor data that does not start with "/" - i.e. the data that needs to be processed.
Note: To simplify things for reproducing the use case, I created a standalone XSD that represents the Ref Cursor output, and I'm using ReadXML to allow me to parse the posted data. In reality, the filtering of the recurring nodes should happen in the map outputs of the stored procedure activity. The actual sequence of steps should be:
1) Execute the stored procedure
2) Filter the output using the XPath I'm using
3) Serialize the data using the same flat-file schema
4) Write the serialized output to the target system using FTP Put, or whatever appropriate activity fits the solution.
Attached is the project file and zipped XSD (just in case).
NarasimhaRaoEarla 3100003CJE1 Post
Re: Processing Ref Cursor Output2014-12-24T13:10:16ZThis is the accepted answer. This is the accepted answer.
We did not find the attachment in your post. Could you please provide and help us to handle the ref cursor in Websphere Cast Iron.
Thanks in Advance.