Chapter 5: Processing XML with PL/SQL

ExampleCaptionFilename
5-1Inserting an external XML file into a CLOBinsertXmlFile.sql
5-2Checking the well-formedness of XML in a CLOBcheckXMLInClob.sql
5-3Moving ill-formed XML documents to another table in batchmoveBadXMLDocuments.sql
5-4Parsing XML from a string and using DOMidAttributeOf.sql
5-5Example Moreover.com news feed datagrammoreoverexample.xml
5-6Retrieving an XML-based news feed from Moreover.comparse_xml_news.sql
5-7Controling security on URL access inside Oracle8i JServerallow_url_access.sql
5-8The xml helper package specificationxml_spec.sql
5-9The xmldoc helper package specificationxmldoc_spec.sql
5-10The xpath helper package specificationxpath_spec.sql
5-11Test, extract, and retrieve an XPath expression valuetestxpath.sql
5-12Storing XML insurance claim in multiple tables with XPathxml_claim_spec.sql
5-13Testing the xml_claim packagetestxmlclaimstore.sql
5-14Ruleset document describes a set of XPath validation rulesAbstractSubmissionRules.xml
5-15Routines to administer XPath validation rulesxpath_rules_admin_body.sql
5-16Validating XML document against an XPath Rulesetxpath_rules_body.sql
5-17Sending an email from inside Oracle8i using PL/SQLsendMail.sql
5-18Procedure to coordinate new paper submission handlinghandleNewSubmission.sql
5-19Two sample abstract submissions to processAbstract_With_Error.xml
5-20The xml_http helper package specificationxml_http_spec.sql
5-21Implementation of xml_http helper packagexml_http_body.sql
5-22Posting XML-based news stories to another web serverpostNewsStory.sql
5-23The xmlq helper package specificationxmlq_spec.sql
5-24Dequeuing messages until a queue is emptyxml_dequeue_test.sql
5-25Serving SQL query results for an accepted submission in XMLsubmissionXML_CLOB.sql
5-26Stylesheet to transform ROWSET/ROW to TechnicalPaperTechnicalPaper.xsl
5-27The xslt helper package specificationxslt_spec.sql
5-28Modified submissionXML function uses the xslt helper packagesubmissionXML.sql