"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
news:1a75df45.0308190244.f2d9fa0_at_posting.google.com...
> "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.
There isn't one, but there are a couple of quick and dirty alternatives
listed at the FAQ on jonathans site.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Tue Aug 19 2003 - 07:05:23 CDT
