Toad crashes when displaying XMLTYPE within object type
说明
Steps to reproduce:
create a test type CREATE TYPE t_test_xml_type IS OBJECT (xml_doc sys.xmltype); /
create a table with a test type column CREATE TABLE test_xml_type_table (test_id INTEGER, test_xml_obj t_test_xml_type); /
insert testdata into the table INSERT INTO test_xml_type_table (test_id, test_xml_obj) VALUES (1, t_test_xml_type(xmltype('<Testentry />')));
printing it to dbms_output -> works fine: begin for res in(SELECT * FROM test_xml_type_table) loop dbms_output.put_line(res.test_xml_obj.xml_doc.getclobval); end loop; end;
show result in Data Grid -> Toad crashes SELECT * FROM test_xml_type_table;
解决办法
WORKAROUND: None
STATUS: Waiting for a fix to be released in a future version of Toad for Oracle.