Re: Registering My XML Schema Before Using Oracle XML DB

Hi "r" <t>, you said...
> 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"
> xmlns="C:\xml_test\XMLSchema">
> </schema>';
> begin
> dbms_xmlschema.registerSchema('c:\xml_test\xml.xsd', doc);
> end;
> 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?
>
> Thank you
>

I have just started looking into Oracle's XML capability, so I'm a novice at this and my answer might be incorrect. :)

You might want to look at the articles that appear in Oracle magazine, which you can get online at OTN ... for example (From XML to Storage and Back, in the March/April 2003 issue):

http://otn.oracle.com/oramag/oracle/03-mar/o23xml.html

Doesn't the first argument to dbms_xmlschema.registerSchema have to be a URI, not a file (as you have)? According to the magazine article, it should be something like this:

'http://127.0.0.1/.../xml.xsd'

Like I said, I'm just starting with this stuff, so I might be wrong. You can also do a Google search for dbms_xmlschema and get a number of hits.

-- 
[:%s/Karsten Farrell/Oracle DBA/g]