hi everybody,
I have the following problem. I want to retrieve data from Oracle DB. I execute the following sentence:
"Select count(*) from X". I'm doing that by means of action=SQL_QUERY. The response is something like that:
<?xml version="1.0" encoding="utf-8"?>
<ns0:MT_WM02_request_bbdd_count_response xmlns:ns0="urn:xxx-com:xi:xxx_WM">
<STMT_response>
<row>
<COUNT()>32</COUNT()>
</row>
</STMT_response>
</ns0:MT_WM02_request_bbdd_count_response>
The problem is that I can't map the response because the Integration Builder doesn't allow to develop this kind of element on the Data Type. I mean <COUNT()>. The symbols '(' and '' are not permitted.
How can I solve the problem?
Thanks in advance,
Regards
Carlos