Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Working with XML in Oracle

By Exforsys | on August 30, 2007 |
XML Tutorial

Working with XML in Oracle

Introduction to XML

Extensive markup language is the language which presents data in a human readable form of text. The data can be anything from a purchase order or a stock quote or weather radar or a flight schedule it can be represented using XML. XML is very similar to HTML in its functionalities because even XML uses the open tag and the close tag.

But the difference between the both is that the HTML has a set of fixed tags and you have to use something from the specified list and in XML you can use your own tags. These tags can be something which is related to the industry you are in or you can also come up with your own tags and define them. The data that is presented in XML is called an XML document which can be quantified as one unit of data. For example each purchase quote can be called one XML document.

When these XML documents are transformed form one place to another or one system to another system in the packets it is called a datagram. XML documents are usually well structured and well formed documents because they follow the syntax rules correctly and follow the standards exactly the way they are set such as the rule that the start tag and the end tag should always match with each other. This way the XML tags allow you to create a clean and structured form of data.

Tools for XML in Oracle applications

Oracle offers something called the MXL developer’s kit or the XDK which provides all the functionalities of XML in the Oracle 8i environment and even in the Oracle 9i environment. The intermediate text which has started in the Oracle 8i has been built around XML and has an increased awareness for being compatible with XML.

In addition to all of these the developer also includes a lot of functions which were built to work along with XML in coalition. But people who work on Oracle versions which were released before the oracle 8i came into picture cannot directly use the XML but for these people a version of XML called the PLSXML which is a utility based on ML is available and gives the users the same advantages XML gives to oracle 8i users in terms of functionality for the Sequel Applications.

The XML Developer Kit

Ever since Oracle 8i was released, the XML developer’s kit has come along for Oracle developers. The XML Developer’s kit has basically integrated itself into the database ad automatically installs itself along with the database whenever it is installed. PL/SQL can also be used to access the XML developers kit. Even programming languages like Java, C and C++ are used to access the XML developer’s kit.

Sequel Applications have a limitation that they have to run inside the database only for example programs like the packages or stored procedures if you have to access the XML developer’s kit. Where as the java applications may be inside the database or outside the database it doesn’t matter to the XML developer’s kit. C and C++ by default are located outside the database and there is no other possibility that exists in their case.

If you have to access the XML developer Kit from a Pl or Sequel or even Java applications for that matter you will have to install the Java virtual machine or JVM and also known as the Jserver. It is quite contradictory that you have to install a jserver or Oracle Java virtual machine installed in order to be able to use the java virtual machine because the XML developers kit was written in Java, this fact has given birth to the need for JVM. Oracle puts wrappers from PL/SQL on the java code so that it is accessible from the PL/SQL.

The XML developers Kit includes an XML parser along with an XSLT processor and also an XPath engine which comes with XSQL page processor and a servlet and additional XML SQL utility. The XDK and the XML parser and the XSLT processor were implemented by Oracle to make itself more adaptable to XML so that it can work cohesively with XML but the XSQL page processor and the XML SQL utility are Oracles own feature which were introduced long with the borrowed features. These elements function together in coordination.

However the XSQL page can be accessed only through the Java applications or the Java virtual machine. In the previous versions of the XDK the XML SQL utility was a tool by itself separate from the XDK and also had to be installed separately, but now it has been built into the XDK and can be installed while the XDK is being installed.

XML Parser, XSLT Processor, and XPath Engine

The main function of an XML parser is to parse and also validate the XML document and builds an info set data structure in the memory, the functions also include manipulating the info set and then write the same data back into the XML document. The PL/SQL applications can gain access to the XML parser by using the functions called xmlparser and xmldom. Java applications provide default access to java classes. The XML documents enable the transformation into various XML document types or other formats of file using the XSLT. The PL/SQL will let you access the XSLT only when there is XSLT processor package.

You can also use something called oraxsl program to transform directly form the command line. All you have to do is give the name from the command line and give the name of the XML document that has to be transformed and a description about the style sheet which will transform and a file name for the output file. The same file can be used to transform many more documents in batches from the script.

The XDK also uses the Xpath engine because the XML parser and the XSLT processor which are an integral part of the XXDK use the Xpath engine. Functions like calling the XMLDOM in a PL/SQL package for example is the job of the Xpath engine and typically the users do not have to interact with the XML developer’s kit Xpath engine.

The XSQL Pages

For XML data to be published the X sequel provides a wide platform and an extensible framework. This facility is only available in the Java programs and not in Oracle. The XSQL page facility is inbuilt with the XSQL page processor and an XSQL servlet and also includes a program that will run directly from the command line. The servlet can also run with Apache, the Oracle 9i database. The command line program and the java servlet both call for the XQL page.

Publishing data has become very easy since the XSQL pages have been introduced. XML documents can be easily created using the XSQL document type data. The document also has the capability to encapsulate the data and SQL queries; it also can efficiently identify all the parameters that are passed through as a URL or even command line arguments. When the command line is used in the program the servlet is called and the query also is executed. Then the results of the query are then converted into XML.

The XML SQL Utility

The XML SQL utility is used to further simplify the loading and the retrieving activity of XML documents when the tables, rows and columns are used from the table, which are in turn used to represent the various segments of the XML document. An XML document is well structured can be passed to the XML SQL utility and the function of this utility is to insert the rows inside the database table.

Queries can also be submitted into the XML document which will be formatted into the document using this function. The XSLT can also be used after the querying is over or before the querying starts that the inputs can be made and the outputs turn out to be more flexible. This utility also includes the facility to update and delete the data in the database so that the XML SQL utility can be used.

Java API and the PL/SQL API are used to call the XML SQL utility from the command line. In the PL/SQL environment the XML SQL will appear like packages which are also called the DBMS or the data base management service Xml query or the data base management Service XML slave. This command can be invoked using the Java and Oracle XML. On the whole the concept which underlies the XML and its functions when associated with various programming languages and environments are all very simple.

The simple tools associated with the XML can make complex programs and complex networks run effortlessly. After Microsoft even Oracle has realized the true capabilities of XML and has jumped into the bandwagon along with Microsoft that it can harness all the goodness that XML has to offer. Every variation of Oracle and all the latest versions have unspoken bias to XML and are automatically inbuilt with the XML enabled components.

« « Why your Supply Chain Costs are too High
Working with XML in Flash » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Free Training

RSSSubscribe 394 Followers
  • Popular
  • Recent
  • XML Spy

    August 24, 2007 - 0 Comment
  • Working with XML in C

    September 7, 2007 - 0 Comment
  • Using XML with Microsoft Excel

    August 24, 2007 - 0 Comment
  • XML Advantages

    July 5, 2007 - 0 Comment
  • Working with XML in Visual Basic

    August 28, 2007 - 0 Comment
  • XML Disadvantages

    July 8, 2007 - 0 Comment
  • XML Web Services

    July 11, 2007 - 0 Comment
  • XML Introduction

    May 14, 2006 - 0 Comment
  • XML Parsing

    July 14, 2007 - 0 Comment
  • XML – Elements, Attributes, Entities

    May 14, 2006 - 0 Comment
  • Working with XML in C

    September 7, 2007 - 0 Comment
  • Working with XML in Perl

    September 6, 2007 - 0 Comment
  • Working with XML in Python

    September 2, 2007 - 0 Comment
  • Working with XML in Flash

    August 30, 2007 - 0 Comment
  • Working with XML in Visual Basic

    August 28, 2007 - 0 Comment
  • Using XML with Microsoft Excel

    August 24, 2007 - 0 Comment
  • XML Spy

    August 24, 2007 - 0 Comment
  • XML and Service Oriented Architecture

    July 25, 2007 - 0 Comment
  • XML SQL Server

    July 23, 2007 - 0 Comment
  • XML Security

    July 21, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Working with XML in C
  • Working with XML in Perl
  • Working with XML in Python
  • Working with XML in Flash
  • Working with XML in Visual Basic

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2023. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.AcceptReject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT