Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how to register schema DBMS_XMLSCHEMA.registerSchema

Posted on 2006-07-13
9
Medium Priority
?
7,982 Views
Last Modified: 2012-08-14
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.
0
Comment
Question by:dplinnane
  • 3
  • 3
7 Comments
 
LVL 14

Expert Comment

by:sathyagiri
ID: 17102539
Do you habe a /xml folder on your oracle server?
The file address.xsd should be on your oracle server I guess.
0
 

Author Comment

by:dplinnane
ID: 17102683
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.
0
 
LVL 14

Accepted Solution

by:
sathyagiri earned 1000 total points
ID: 17103659
Logon to your Oracle server and check if there is a directory named XML.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:dplinnane
ID: 17103741
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
0
 
LVL 14

Expert Comment

by:sathyagiri
ID: 17103803
Where is the address.xsd file located?
0
 

Author Comment

by:dplinnane
ID: 17105264
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.
0
 
LVL 16

Assisted Solution

by:MohanKNair
MohanKNair earned 1000 total points
ID: 17105795
The schemaurl can be an http URL accessible from oracle server

BEGIN
  DBMS_XMLSchema.registerSchema(
    schemaurl=>'Schema URL',
    schemadoc=>
END;
/


See this link
http://www.oracle-base.com/articles/9i/XMLDB9i.php
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

572 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question