Sorry, missed that one.
You've probably already figured it out by now.
This is wrong.
The XML message doesn't start with "ns2:consultaCooperativistaResponse", you're missing the SOAP envelope elements :
And unless you're running an old version of Oracle db (pre 10.2), XMLSequence, extract and extractvalue are deprecated. Use XMLTable instead, much more easier to use.