René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

ORA-19010

set serveroutput on size 10000

declare
  success boolean;
begin

  success := dbms_xdb.createResource(
    '/public/ora-19010-test.xml',
    '<a>
      <b>foo</b>
      <b>bar</b>
      <c>baz</c>
    </a>');

  if success then
     dbms_output.put_line('success');
  else
     dbms_output.put_line('no success');
  end if;

end;
/
create table ora_19010_test as 
select XMLQuery ('doc("/public/ora-19010-test.xml")//b'
                 returning content) xml_content
  from dual;
ORA-19010: Cannot insert XML fragments
create table ora_19010_test as 
select XMLSerialize(content XMLQuery ('doc("/public/ora-19010-test.xml")//b'
                 returning content)) xml_content
  from dual;