Issue while reading store procedure output in OIC.
Summary:
Hi All
We are facing an issue while reading Stored Procedure out put in OIC. SP is providing the response as xml tags. But when it is received in OIC the tags are getting converted as :
<CrewDetailsCollection>
<CrewDetails>
<CREW_ID>4154</CREW_ID>
<EXT_SYS_TYPE>00</EXT_SYS_TYPE>
</CrewDetails>
</CrewDetailsCollection>
We tried using the below functions but no luck
oraext:parseEscapedXML (oraext:get-content-as-string())
Also, we tried to read it as comma separated output from stored procedure. But while OIC receives the output, a tab space is getting appended.
Crew ID,Crew Name,Status,Division,Center Name