Chapter 5: Processing XML with PL/SQL
Example
Caption
Filename
5-1
Inserting an external XML file into a CLOB
insertXmlFile.sql
5-2
Checking the well-formedness of XML in a CLOB
checkXMLInClob.sql
5-3
Moving ill-formed XML documents to another table in batch
moveBadXMLDocuments.sql
5-4
Parsing XML from a string and using DOM
idAttributeOf.sql
5-5
Example Moreover.com news feed datagram
moreoverexample.xml
5-6
Retrieving an XML-based news feed from Moreover.com
parse_xml_news.sql
5-7
Controling security on URL access inside Oracle8i JServer
allow_url_access.sql
5-8
The xml helper package specification
xml_spec.sql
5-9
The xmldoc helper package specification
xmldoc_spec.sql
5-10
The xpath helper package specification
xpath_spec.sql
5-11
Test, extract, and retrieve an XPath expression value
testxpath.sql
5-12
Storing XML insurance claim in multiple tables with XPath
xml_claim_spec.sql
5-13
Testing the xml_claim package
testxmlclaimstore.sql
5-14
Ruleset document describes a set of XPath validation rules
AbstractSubmissionRules.xml
5-15
Routines to administer XPath validation rules
xpath_rules_admin_body.sql
5-16
Validating XML document against an XPath Ruleset
xpath_rules_body.sql
5-17
Sending an email from inside Oracle8i using PL/SQL
sendMail.sql
5-18
Procedure to coordinate new paper submission handling
handleNewSubmission.sql
5-19
Two sample abstract submissions to process
Abstract_With_Error.xml
5-20
The xml_http helper package specification
xml_http_spec.sql
5-21
Implementation of xml_http helper package
xml_http_body.sql
5-22
Posting XML-based news stories to another web server
postNewsStory.sql
5-23
The xmlq helper package specification
xmlq_spec.sql
5-24
Dequeuing messages until a queue is empty
xml_dequeue_test.sql
5-25
Serving SQL query results for an accepted submission in XML
submissionXML_CLOB.sql
5-26
Stylesheet to transform ROWSET/ROW to TechnicalPaper
TechnicalPaper.xsl
5-27
The xslt helper package specification
xslt_spec.sql
5-28
Modified submissionXML function uses the xslt helper package
submissionXML.sql