Oracle Checking for XML wellformedness

2012-02-01  Source: Original Site  Category:Oracle  Views:0 

Advertisement

I think I am overlooking something. Anyway...

Loaded thousands of XML documents into the repository by creating them as resources. I want to test the resources on XML wellformedness and XML Schema validation.
The last one is not very difficult and works okay with the functions at hand as for instance described in the FAQ, but...

How do I check for XML wellformedness...?
What would be the fastest way to check?

I could write a small PL/SQL wrapper "ISXMLWELLFORMED" around XMLType () (http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/t_xml.htm#i1009842), but I could maybe run into buffer problems.

The simple tests are:

1) Loading thousands of XML "production" documents via a SAX loader (ranging from 1.5 Mb down to 25 Kb). 2) Storing them initially in a XMLType CLOB 3) Generating / creating resources from the documents into the repositoy (also checking XDB$RESOURCE behaviour) 4) Now I have my test start position. 5) Checking content: a) Checking (timed) XML resources on wellformedness b) Checking (timed) XML resources against nested XML Schemas (three layers via "include" namespace references)

Environment

*) SGA and other database parameters are set by hand (no automatic parameters are enabled). *) Only SQL, PL/SQL and XMLDB functionality is installed. *) For the moment ASSM locally managed tablespaces are used. *) Recycle bin feature is disabled, etc. *) I have two database systems setup to check validation performance (Oracle 10.2.0.3 SE on Oracle EL 5 and 11.1.0.6.0 SE on Oracle EL 5).

Also, now that I am at it.

Any idea on the best way to check on Lazy or Strict DOM validation (controlled via xdb:maintainDOM / XMLType()? ) ?

A general outline is good enough.../ a hint would be appriaciated...

M.

Message was edited by:
Marco Gralike

Related articles
  • Oracle Checking for XML wellformedness 2012-02-01

    I think I am overlooking something. Anyway... Loaded thousands of XML documents into the repository by creating them as resources. I want to test the resources on XML wellformedness and XML Schema validation. The last one is not very difficult and wo

  • Oracle Check for Character input 2013-01-10

    I’m new in PL/SQL development. I need to check for the user input and make sure that after I prompt user he/she must have entered a number NOT A CHARACTER. Does Oracle has any function to check for character input?

  • Check for XML child 2013-07-08

    I need some help for checking for the following: <?xml version="1.0" encoding="ISO-8859-1"?> <error> <err type="2">Invalid location provided.</err> </error> Heres my PHP code $hold = array(); $v_URL = "http://xoap.weathe

  • Oracle Checking for Overlapping Dates? 2014-01-08

    Suppose I have a table which stores details of exclusive licenses for a product, so that the table contains a START_DATE and END_DATE for a license. I want to write a function which, if fed a proposed start/end date for a new license will check to se

  • Oracle check for file name using FILE_BROWSE 2015-03-01

    I have a file_browse item in an APEX page and a submit button which loads the contents of the file into an oracle table. everything is working, but I need to put in a check for file name. Meaning, user is only allowed to load a file with a very speci

  • Oracle Check for Updates 2012-02-01

    I am using JDeveloper 9.0.3.2 build 1145 and I wanted to get the extensions for JUnit test cases. The documentation recommends using the 'Check for Updates' menu option on the Help menu. I did this and ran through the wizard inputing the same usernam

  • Oracle Checking for existence of at least one result? 2012-03-05

    Is there a way to make a simple SQL query that will check for the existence of any results from the query, and preferably, stop after finding the first row, if it exists (for speed)? Or can this only be done by using a cursor in a stored proc?

  • Oracle check for a range of ascii chars 2012-04-03

    I want to check for ascii chars in the range of 1-32. What is the best way to do this? I can use 'instr' to search for one char. How can I check for a range of chars? My sql will return a string and I want to trap ascii from 1-32 in this string.

  • Oracle Check for non-numeric characters in textbox input 2012-04-14

    I have a form with several textboxes, each of which can accept numeric input. I want to write a validation/ plsql block that checks for a non-numeric character in the input, so that my user sees a customized error message rather than a database error

  • Oracle checking for errors in application item computation (at page level) 2012-05-13

    I have a conditional computation used to set the value of an application-level item. In the condition, I need to check to see if the action (button-press to initiate DML processing) generated an error (eg cannot delete row because of child records).

  • Oracle help for XML DB 2012-09-11

    pls anyone give me the your own prepared tutorials or notes for XML DB and one example for loading xml data into tables

  • Oracle check for blank spaces 2013-03-12

    here is my table and the data yard ID - '999' description - ' ' values are inside the quotes, but not including it notice the empty space in the description column when i do a query like this: select * from yard where description = ' ' it works howev

  • Oracle Check for Duplicates 2013-08-20

    I have a list of numbers I want to quickly check for duplicates. I vaguely remember there being a way to use some 'EXISTS' syntax but that is all. Does anyone have the code?

  • Oracle Checking for existing Rollback Segments 2013-10-11

    Is there a possibility to check for existing rollback segments within procedures?

  • Oracle Checking for duplicate primary keys on row inserts 2014-02-11

    Checking for duplicate primary keys on row inserts I have a situation where I will be making bulk table inserts knowing that the primary key value will in some cases already exist. In this is the case I simply want to ignore the duplicate inserts. Sh

  • Oracle Checking for NOT EQUAL TO (Strings) in PL/SQL 2014-03-23

    I am trying to compare two strings in an IF statement, for NOT EQUAL TO. IF (string1 string 2) THEN ... do specific task END IF; But this didn't work (there is no doubt about it, I tested it thoroughly and noticed that it didn't work). Then I changed

  • Oracle Check for Updates... doesn´t login 2014-05-13

    if I try to update JDeveloper 9.03 via the Menu Help-->Check for Updates... I can´t login with my username and password. I have also tried the password finder, which gives twice the same answer, but doesn´t do it either. Even with another User/Pas

  • Oracle Checking for primary key violation 2014-07-12

    In a PRO*C program I want to check for primary key violation (MyPK). For best performance i must first check for the existence of the record: EXEC SQL SELECT COUNT(*) INTO :c FROM MyTable WHERE MyPK = 'PKValue'; if (c!=0) printf("ERROR record exist .

  • Oracle Checking for invalid objects 2014-12-09

    Following query is to check for invalid objects. SELECT OWNER,SUBSTR(OBJECT_NAME,1,40) OBJECT_NAME,OBJECT_TYPE,STATUS, CREATED FROM SYS.DBA_OBJECTS WHERE STATUS='INVALID' AND OWNER NOT IN ('SYS','SYSTEM','DBSNMP','MDSYS'); My questions are.. 1. What

  • Oracle Check for spaces embedded with in a field 2014-12-18

    I need to check for spaces in a field. The field is char(8). I need to check for spaces in between. Example: ' 1 2' '1 2' ' 12' Leading spaces and spaces between the chars. the spaces can be more than 1. Is this possible in just SQL?