DISQUS

DISQUS Hello! Eddie Awad’s Blog is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Eddie Awad’s Blog

News, views, tips and tricks on Oracle and other fun stuff
Jump to original thread »
Author

XML Goodness in SQL - Part 1

Started by Eddie Awad · 8 months ago

Here are some cool and useful things you can do with XML using pure SQL in an Oracle database.

HTTPURIType

The HTTPURIType provides support for the HTTP protocol. It uses the UTL_HTTP package underneath to access the HTTP URLs. With HTTPURIType, you can create objects that represent link ... Continue reading »

2 comments

  • I don't know how I missed HTTPURIType.getxml in the Oracle docs. It makes dealing with REST web services like the Google Maps API geocoder much easier. I'd been using UTL_HTTP, getting the data in pieces as a CLOB, then casting it as an XMLTYPE. This skips all that stuff. Thanks for pointing it out.
  • @John yes, HTTPURIType is very handy. I wish it could handle basic HTTP authentication as well.

Add New Comment

Returning? Login