OraFAQ Forum: JDeveloper, Java & XML » Problem in validating the XML with XSD in Oracle

Home » Developer & Programmer » JDeveloper, Java & XML » Problem in validating the XML with XSD in Oracle

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in validating the XML with XSD in Oracle [message #199441]

Tue, 24 October 2006 05:49

appub
Messages: 2
Registered: October 2006
Location: Bangalore

Junior Member

Hi,

Currently I am facing a problem while validating the XML with the XSD. XML and XSD are <?xml version="1.0" encoding="utf-8"?>.

I am using the following logic to validate the XML:

l_Validatexml xmltype;

l_Validatexml := Xmltype(CLOB).Createschemabasedxml(XSD path);
l_Validatexml.Schemavalidate();

This is working if the XML contains the ASCII characters.

But if the XML contains some german characters for Ex:
<FIRST_NAME>jiag�ad�eesseache</FIRST_NAME>

It is giving the following error:
ORA-31043: Element '' not globally defined in schema ''

Can you please help in this regard.

Regards,
Apparao

Report message to a moderator

Re: Problem in validating the XML with XSD in Oracle [message #199442 is a reply to message #199441]

Tue, 24 October 2006 05:54

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Oracle

ORA-31043: Element 'string' not globally defined in schema 'string'

Cause: The specified element name has not been defined at the top level of the XML schema (i.e. globally). Elements must be defined globally to be the root of an XMLType object.

Action: Check the XML schema definition to make sure the specified element name has been defined at the top level.

Also, check this experience.

Report message to a moderator

Re: Problem in validating the XML with XSD in Oracle [message #199444 is a reply to message #199442]

Tue, 24 October 2006 06:06

appub
Messages: 2
Registered: October 2006
Location: Bangalore

Junior Member

But this is not the case when i validated the XML with out german characters. It is working fine.

When i use the German or French (NON ASCII) in the values for ex:
<FIRST_NAME>jiag�ad�eesseache</FIRST_NAME>

then only this problem is arising.

Please clarify

Report message to a moderator

Previous Topic:	format/indent XML output
Next Topic:	OC4J error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:20:12 CST 2024