Issue while reading store procedure output in OIC. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue while reading store procedure output in OIC.

edited Jul 23, 2025 7:21PM in Integration 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!