Home » SQL & PL/SQL » SQL & PL/SQL » Return XML from the database
Return XML from the database [message #197237] Tue, 10 October 2006 13:13 Go to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Hi,

We are trying to retuen XML from database, this is first time so any examples or help on this.

Second thing i tried to run this file
/oracle/product/9.2.0/rdbms/initxml.sql


I am getting this error.
 dbms_registry.loaded('XML', '9.2.0.7.0', 'Oracle XDK for Java Release 9.2.0.7.0 - Production');
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_REGISTRY' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored
 
 
 
Warning: Procedure created with compilation errors.
 
BEGIN xmlvalidate; END;
 
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SYSTEM.XMLVALIDATE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 


 dbms_registry.loaded('XML', '9.2.0.7.0', 'Oracle XDK for Java Release 9.2.0.7.0 - Production');
   *
ERROR at line 2:
ORA-06550: line 2, column 4:
PLS-00201: identifier 'DBMS_REGISTRY' must be declared
ORA-06550: line 2, column 4:
PL/SQL: Statement ignored
 
 
 
Warning: Procedure created with compilation errors.
 
BEGIN xmlvalidate; END;
 
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SYSTEM.XMLVALIDATE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


What am i missing here, is there any dependent packages to run before this.
Thanks

Re: Return XML from the database [message #197239 is a reply to message #197237] Tue, 10 October 2006 13:19 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
which user/schema was logged in & invoked @/oracle/product/9.2.0/rdbms/initxml.sql?
Re: Return XML from the database [message #197242 is a reply to message #197239] Tue, 10 October 2006 13:50 Go to previous messageGo to next message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Thanks for Reply

I logged on as system and run that file.

Thanks
Re: Return XML from the database [message #197245 is a reply to message #197237] Tue, 10 October 2006 13:58 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
It appears to me to be owned by SYS.
Re: Return XML from the database [message #197248 is a reply to message #197245] Tue, 10 October 2006 14:02 Go to previous message
faiz_hyd
Messages: 294
Registered: February 2006
Senior Member
Thanks for follow up

Do You mean sys should execute it,


Thanks
Previous Topic: Timestamp column as primary key.
Next Topic: Hierarchical Data
Goto Forum:
  


Current Time: Sun Dec 04 02:50:32 CST 2016

Total time taken to generate the page: 0.09788 seconds