Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    2

    Exclamation Unanswered: Inserting XML document into an XMLSchema-based XMLType column

    Hello,

    I created a table with an XMLType column and
    mapped an XMLSchema to the column.
    I've been trying to insert an XML document into the
    column, but I keep getting the error saying that
    the schema and the document do not match.

    However, I've checked the XML document against
    the schema before running the SQL statement and
    there was no problem. If anyone could please
    help me, that would be great.

    Thanks so much,
    Hyo-Jeong

  2. #2
    Join Date
    Aug 2003
    Posts
    2

    Re: Inserting XML document into an XMLSchema-based XMLType column

    Check the following link in Oracle documentation which explains how to insert data into XMLType column:
    http://download-west.oracle.com/docs...bj.htm#1031944
    Check if you did the same.
    If you are using Java to insert the data then the 'Survey Sample' will be of help for you. Download the sample from the following link:
    http://otn.oracle.com/sample_code/te...y/content.html

    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •