asked on

how to register schema DBMS_XMLSCHEMA.registerSchema

Here is an example
BEGIN
DBMS_XMLSCHEMA.registerSchema(
'http://localhost:8080/source/schemas/poSource/xsd/purchaseOrder.xsd',
XDBURIType('/source/schemas/poSource/xsd/purchaseOrder.xsd').getClob(),
TRUE,
TRUE,
FALSE,
TRUE);
END;

I tried this locally placing my xsd file

BEGIN
DBMS_XMLSCHEMA.registerSchema(
'http://localhost:85/xml/address.xsd',
XDBURIType('/xml/address.xsd').getClob(),
TRUE,
TRUE,
FALSE,
TRUE);
END;
/
I got the following error.

ORA-31001: Invalid resource handle or path name "/xml/address.xsd"
ORA-06512: at "SYS.XDBURITYPE", line 4
ORA-06512: at line 2

I'm assuming it need to go in the oracle apache directory, however I can't seem to find it.

Secondly, I read that registering a schema speeds up performance. I would like a simple explanation why?

Thanks in advance.

sathyagiri

Do you habe a /xml folder on your oracle server?
The file address.xsd should be on your oracle server I guess.

dplinnane

ASKER

I don't know where do I look? Probably not I just crated that in my local apache directory. I do not know where the oracle apache or www dir is under oracel.

ASKER CERTIFIED SOLUTION

sathyagiri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dplinnane

ASKER

This is it.

Volume in drive D has no label.
Volume Serial Number is C79C-34D9

Directory of D:\oraclexe\app\oracle\product\10.2.0\server

06/21/2006 11:55 AM <DIR> .
06/21/2006 11:55 AM <DIR> ..
06/21/2006 11:55 AM <DIR> precomp
06/21/2006 11:55 AM <DIR> oramts
06/21/2006 11:55 AM <DIR> RDBMS
06/21/2006 11:55 AM <DIR> BIN
06/21/2006 11:55 AM <DIR> opmn
06/21/2006 11:55 AM <DIR> config
06/21/2006 11:55 AM <DIR> ctx
06/21/2006 11:55 AM <DIR> nls
06/21/2006 11:55 AM <DIR> ODP.NET
06/21/2006 11:55 AM <DIR> odbc
06/21/2006 11:55 AM <DIR> demo
06/21/2006 11:55 AM <DIR> ldap
06/21/2006 11:55 AM <DIR> NETWORK
06/21/2006 11:55 AM <DIR> xdk
06/21/2006 11:55 AM <DIR> OCI
06/21/2006 11:55 AM <DIR> ODE
06/21/2006 11:55 AM <DIR> jlib
06/21/2006 11:55 AM <DIR> sqlplus
06/21/2006 11:55 AM <DIR> hs
06/21/2006 11:55 AM <DIR> doc
06/21/2006 11:55 AM <DIR> plsql
06/21/2006 11:55 AM <DIR> jdbc
06/21/2006 11:55 AM <DIR> oracore
06/21/2006 11:55 AM <DIR> oledb
06/21/2006 11:55 AM <DIR> LIB
06/21/2006 11:56 AM 52 Database_homepage.url
06/21/2006 11:56 AM 80 Get_Started.url
02/02/2006 12:43 AM 69 Online_forum.url
06/21/2006 11:56 AM 106 Online_help.url
02/02/2006 12:43 AM 77 Read_Documentation.url
02/02/2006 12:43 AM 76 Register.url
06/21/2006 11:55 AM <DIR> slax
06/21/2006 11:55 AM <DIR> database
06/21/2006 11:56 AM <DIR> log
06/21/2006 11:56 AM <DIR> dbs
07/13/2006 12:19 PM 24,051 idx.htm
7 File(s) 24,511 bytes
31 Dir(s) 37,710,594,048 bytes free

sathyagiri

Where is the address.xsd file located?

dplinnane

ASKER

Thats my apache directory that I installed with PHP, I could not find the oracle webserver folder. I stuck it in here to see what would happen.

SOLUTION

MohanKNair

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial