Home » Other » Training & Certification » xml suport on oracle database (oracle 10g)
xml suport on oracle database [message #348895] Thu, 18 September 2008 04:20 Go to next message
pointers
Messages: 410
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 #348898 is a reply to message #348895] Thu, 18 September 2008 04:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you're just doing it wrong.
SQL> select comp_id, version, status from dba_registry where comp_id='xml';

no rows selected

I get the same result but able to do xml stuff.

Regards
Michel
Re: xml suport on oracle database [message #348904 is a reply to message #348895] Thu, 18 September 2008 04:38 Go to previous messageGo to next message
pointers
Messages: 410
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



Re: xml suport on oracle database [message #348908 is a reply to message #348904] Thu, 18 September 2008 04:45 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Use SQL*PLus, it will give you at which line and column it finds the error

2/ registry comes with 9i

3/ xml too any edition.

Regarsd
Michel
Previous Topic: How To Study for a Certification Exam
Next Topic: Oracle Certification self-study
Goto Forum:
  


Current Time: Sun Dec 04 06:21:29 CST 2016

Total time taken to generate the page: 0.08558 seconds