René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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;
See also other Oracle errors.
|