Problem solve

Oracle XML

• Oracle XML capabilities in Oracle Database 11gR2, part 3

  This third part of a series on Oracle XML capabilities explains how to ingest, shred and publish XML data in Oracle Database. Continue Reading

• Oracle XML capabilities in Oracle Database 11gR2, part 2

  In the second and final part of this column on XML capabilities in Oracle Database 11gR2, columnist Jeff McCormick details how XML data can be used in the database and queried to gain business information.  Continue Reading

• Oracle XML capabilities in Oracle Database 11gR2, part 1

  New Oracle XML capabilities in Oracle Database 11gR2 allow for easier reading and manipulation of XML documents, according to columnist Jeff McCormick. In part 1, McCormick introduces the reader to XML capabilities in Oracle Database and sets up a ... Continue Reading

• What is SOA?

  What is SOA and what are its benefits? Continue Reading

• Calling Web service from Oracle vs. .Net

  What are the advantages of calling a Web service from Oracle rather than from .Net? Are there any performance benefits? Continue Reading

• Introduction to BPEL

  It's important for managers, developers and DBAs to have an understanding of how BPEL can benefit them. This article provides an introduction to BPEL including Oracle's BPEL Process Manager.Continue Reading

• Parsing, converting and loading image with XML

  I have to parse an image from XML. The image is in base64 encoded form. I have to parse the image, convert it to binary and load it in a blob in an Oracle database.Continue Reading

• Implementing a Web service in Oracle 10g

  I have three days to begin implementing a Web service using Oracle 10g and an external API for the purpose of looking up geographic specific information and have never used Oracle in a Web service. Please point me to the appropriate resources.Continue Reading

• Developing a parser for recognizing HTML tags

  In my current project, I need to develop a parser for my language. It is actually not a language, but I am working on a project for which I have my own HTML tags and all my work will be based on those tags. Now, I need to find out if it is ...Continue Reading

• Concatenating XML fragments

  Using XMLElement and XMLForest I have created several XML "strings." In a final XMLElement select statement with XMLForest I want to concat the earlier strings within the output of the final statement. Can concat be used within XMLElement or ...Continue Reading

• Generating XML from stored procedures

  What are the best ways to generate XML from stored procedures? I have tried using SQLX with version 9i and it works pretty nice. I would like to know if you can recommend any other ways of doing it and suggest which approach has to be taken in what ...Continue Reading

• Changing the tablespace for an XML schema

  When I register an XML-Schema with dbms_XMLSchema.registerSchema, are the tables created into the default tablespace? Is it possible to change the tablespace for the tables?Continue Reading

• Rolling back Oracle XSU

  Some of the Oracle XSU that I create contains several inserts/updates and I would like the opportunity to rollback if just one of those inserts/updates fails but this seems impossible as I only get the aforementioned int and not Exceptions thrown ...Continue Reading

• CLOB string too long

  When you concatenate, Oracle treats a clob as a varchar2 and then, at over 4000 characters, the string becomes too long to handle. Do you have any ideas to get around this so that I can have larger HTML pages?Continue Reading

• Using the XMLElement function

  Continue Reading

• RDBMS vs. XDBMS

  Continue Reading

• EAI vs. Web services: Different answers to the same problem

  Find out how EAI and Web services differ and how to determine the right approach to your integration problem.Continue Reading

• XML data management: Setting some matters straight, Part III

  If XML is just a physical format for data exchange why does it incorporate logical constructs such as data model components?Continue Reading

• XML data management: Setting some matters straight, Part II

  Fabian Pascal continues his arguments to counter the XML hype machine.Continue Reading

• XML data management: Setting some matters straight, Part I

  The IT industry has a long history of extending technologies to purposes for which they were not intended, including XML...Continue Reading

• Managing data with XML: Forward to the past?

  Fabian Pascal discusses database management with XML.Continue Reading