title: Parse XML or JSON in PL/SQL
body: <p>I want to parse the output of google maps geocode (specifically the longitude and latitude) which is returned. This can be returned in XML or JSON (I do not really have a preference, I just need the information). I am using utl_httprequest to get the JSON or XML from google and then that gets stored in a variable, but I have no idea how to extract the info. I read <a href="http://docs.oracle.com/cd/B10501_01/appdev.920/a96621/adx20ppl.htm" rel="nofollow">http://docs.oracle.com/cd/B10501_01/appdev.920/a96621/adx20ppl.htm</a> but it did not really help. </p>
  
  <p>The google geocode is formatted as such <a href="https://developers.google.com/maps/documentation/geocoding/#GeocodingRequests" rel="nofollow">https://developers.google.com/maps/documentation/geocoding/#GeocodingRequests</a></p>