Auditing an Oracle database for security issues is very important. provides all of the information and tools that you will need Click here for details of Limited's detailed Oracle database security audit service Click here for details of Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Mar 6th, 2021, 5:29am
News: Welcome to Pete Finnigan's Oracle security forum
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Internals
(Moderator: Pete Finnigan)
« Previous topic | No topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: DBURITYPE  (Read 6237 times)
Pete Finnigan Administrator

Oracle Security is easier if you design for it

View Profile | WWW | Email

Gender: male
Posts: 309
« on: Sep 25th, 2005, 6:06am »
Quote | Modify

1. DBURITYPE constructor takes two arguments URL:VARCHAR2 and  
SPARE:RAW. Does anybody know what's the use of the second argument,  
SPARE? Documentation seems to be completely silent about it.  
2. DBUri Servlet allows you to extract more than one row from a table  
by using rowsettag  
With DBURITYPE the documentation says: "A DBUri must identify exactly a  
single data value, either an object type or a collection. If the data  
value is an entire row, you indicate that by including a ROW node. The  
DBUri can also point to an entire table."  
If you try using DBURITYPE to return more than one row (except for when  
returning a full table) you'll get this error message: ORA-19003:  
Missing XML root element name.  
OK, XPath refers a single row.  
OK, returns the whole table  
ORA-19003: Missing XML root element name  
ORA-06512: at "SYS.DBURITYPE", line 21  
ORA-06512: at "SYS.DBURITYPE", line 31  
ORA-06512: at line 1  
Is there a way to make DBURITYPE return more than one row? Could SPARE  
argument play a role in this?  
This behavior doesn't seem to make any sense to me. It's OK to have  
DBUri Servlet return more than one row but with DBURITYPE you have to  
give a path that either returns the whole table or exactly a single row.
IP Logged

Pete Finnigan (
Oracle Security Web site:
Oracle security blog:
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | No topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board