This content has been marked as final. Show 4 replies
One option is to create a wrapper database proc on top of this ref cursor proc that has object type as input.
Map this to the ref cursor.
Consider this option if you are constrained to not replace the ref cursor proc.
If you can change the ref cursor proc, please do so to object type.
I was trying to create a wrapper procedure by passing the xml from bpel and extracting it in the procedure before inserting into the table.
The problem is that the xml is of the below type:
Here the tag <Promo> and the subtag <tag2> are unbounded.
So now I am unable to extract the xml using extractvalue.