Re: Registering My XML Schema Before Using Oracle XML DB

"r" <t> wrote in message news:<bhqdo5$jc51_at_doiweb4.wob.vw.vwg>...
> Hy- I have a problem:
> I cann not a not a Registering My XML Schema Before Using Oracle XML DB.
>
> PROCEDURE XML_TEST_ALTE IS
> doc varchar2(1000) := '
> <schema
> targetNamespace="C:\xml_test\xml.xsd"
> xmlns:po="C:\xml_test\xml.xsd""r" <t> wrote

> ORA-31011: XML-Parsing nicht erfolgreich
> ORA-19202: Fehler bei XML-Verarbeitung
> LPX-00240: element-start tag is not well formed
> Error at line 4
> aufgetreten
> ORA-06512: in Zeile 7
>
> What is not rong?

19202, 00000, "Error occurred in XML processing%s" // *Cause: An error occurred when processing the XML function // *Action: Check the given error message and fix the appropriate problem

The given error mentioned is:

31011, 00000, "XML parsing failed"
// *Cause: XML parser returned an error while trying to parse the document.
// *Action: Check if the document to be parsed is valid.

Thus Oracle deems your XML document invalid. The next error in the sequence indicates the error:

00240, 00000, "element-start tag is not well formed" // *Cause: A start-element tag was improperly formed. // *Action: Check and correct the start-element syntax.

Oracle even tells you where it encountered the error in the document:

Error at line 4

Just *read* the Oracle error messages. The vast majority of times these tell you *exactly* what is wrong.

Also use the oerr Oracle command (in $ORACLE_HOME/bin) to get more detail about the error. Unsure what the Oracle Windows equivalent is.

--
Billy