| xml suport on oracle database [message #348895] |
Thu, 18 September 2008 04:20  |
pointers
Messages: 451
Registered: May 2008
|
Senior Member |
|
|
Hi,
I am new to XML on oracel database, trying to generate a xml from database table and load in my machine. From our forum i got a link but, I am not able to use any xml related commands in my database.
What are all the set up needed for the database to support. Do i need to run any scripts for this.
Please find the below details.
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL> select comp_id, version, status from dba_registry where comp_id='xml';
no rows selected |
|
|
|
|
|
| Re: xml suport on oracle database [message #348904 is a reply to message #348895] |
Thu, 18 September 2008 04:38  |
pointers
Messages: 451
Registered: May 2008
|
Senior Member |
|
|
I have executed the following query. which i got it from our forum..
select dbms_xmlquery.getxml('select * from t_appliction where rownum <= 3') from dual;
/
*
ERROR at line 1:
ORA-00911: invalid character
What kind of oracle edition (enterprise, personal etc.) supports this xml feature..?
In general do we need to execute any scripts to support this.
As, i have another database which is oracle 8 vesion. In that I have executed the following query and got error as..
SQL> select comp_id, version, status from dba_registry where comp_id='xml';
select comp_id, version, status from dba_registry where comp_id='xml'
*
ERROR at line 1:
ORA-00942: table or view does not exist
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
