How do you pass an ampersand (&) through UTL_HTTP?
Hello,
I'm writing a PL/SQL package that connects to an API, and when I send data that includes an ampersand (&) it appears that the body of the request I'm sending cuts off at that point.
The data being sent is in XML format. As an example, if I send this data:
<Event>
<Address>
<AddrLine1>130 SOUTH MAIN ST</AddrLine1>
<AddrLine2>ROOM 140 & 142</AddrLine2>
<City>ST LOUIS</City>
<State>MO</State>
<Zip>63106</Zip>
<Country>US</Country>
</Address>
</Event>
I get this error back from the API:
XML is invalid: Unexpected end of file has occurred. The following elements are not closed: AddrLine2, Address, Event