-- SQL code to read and parse a remote XML and see the results as if it where a regular table

WITH test AS (
SELECT xmltype(utl_http.REQUEST('http://ws1.webservices.nl/rpc/get-simplexml/addressReeksPostcodeSearch/ROCMondriaan_User/86719a838b5f191358456be8e771bf0e/2521DB72')
) column_name FROM dual)
SELECT
extractValue( column_name, '/response/straatnaam','' ) straatnaam,
extractValue( column_name, '/response/plaatsnaam','' ) plaatsnaam
FROM test