XML (XMLType) inside PL/SQL Oracle 9/10

The XMLType is an OO XML aware data type. It can be used in columns or in PL/SQL just like VARCHAR2 or DATE. XMLType has member functions that allow access to data using XPath.

A quick example extracting a specific value from an XML varchar2 string:
DECLARE
v VARCHAR2(32000) := 'ABC';
x XMLType;
BEGIN
x := XMLType(v);
DBMS_OUTPUT.put_line(
x.extract('/DATA/LINE[1]').getStringVal()
);
DBMS_OUTPUT.put_line(
x.extract('/DATA/LINE[1]/text()').getStringVal()
);
END;

Comments

Anonymous said…
Good to see OO XML type integrated in Oracle, there must be some equivalent of this in upcoming Yukon
October 28, 2005 at 2:43 PM
Post a Comment

Popular posts from this blog

Cloud Computing

Cloud computing is a popular phrase which is used for applications that are developed to be rich Internet applications (AJAXed - like Desktop Apps) that run on the Internet (or "cloud"). In the cloud computing paradigm, software that is traditionally installed on personal computers is shifted or extended to be accessible via the Internet. These "cloud applications" or "cloud apps" utilize massive data centers and powerful servers that host web applications and web services. They can be accessed by anyone with a suitable Internet connection and a standard web browser. The architecture behind cloud computing is a massive network of "cloud servers" interconnected as if in a grid running in parallel, sometimes using the technique of virtualization to maximize computing power per server. ------------------------- Google, the most visible example, took cloud computing a step further and directly challenged Microsoft by offering a suite of free word-p...
Read more

Process XML in Dot Net -> Parse to Object

Here we consider a small aspect found while parsing XML string. We are using Dot Net (1.1) but we process xml in general (non-dotnet specific version) using the XPath expressions. Situation is we have XML string format as: task TASK_COMPLETE 02000016000004630144000100000070 02000016000004630154000200000070 2007-09-06T15:26:25+04:00 = strXMLMsg Scene 1: Dim xmlDoc As New Xml.XmlDocument xmlDoc.LoadXml(strXMLMsg) strXPath = "/XMLMessage /EventName" xmlNode = xmlDoc.SelectSingleNode(strXPath) strData = xmlNode.InnerText In this seen we will not be able to get our parsed data. And the issue is the inclusion of the namespace and its prefix. So to get the parsed data correctly we have to use the way shown in scene 2. Scene 2: Dim xmlDoc As New Xml.XmlDocument xmlDoc.LoadXml(strXMLMsg) xsn = New Xml.XmlNamespaceManager(xmlDoc.NameTable) XMLNamespace = "http://domain.com/codename/MessagesXMLSchema.xsd" XMLNamespacePrefix = "ns" xsn.AddNamespac...
Read more

Running multiple versions of the Framework in ASP.NET

Like any good technology, ASP.NET continues to evolve as new versions are released. But, like anything else, this brings with it a number of considerations. Microsoft has done a great job of allowing multiple versions of the framework to run side by side. Version v1.0, v1.1 and v2.0 can all run together at the same time on the same server. There are a couple catches to consider with running multiple versions of the framework side by side. Worker Process is the one that hosts a particular framework version. There is one per version of the framework. (v1.0, v1.1 and v2.0). If a process for a particular version of the framework doesn't exist, as soon as it's needed, a new process will be spun up. This allows multiple versions of the framework to live beside each other in IIS. aspnet_wp.exe is the worker process with IIS 5, w3wp.exe is the worker process with IIS 6. IIS 6 was an impressive upgrade that brought with it some new concepts. One key new concept is Application Pools. A s...
Read more