Helene Member³ Nov 19, 2004 #1 How can I generate a large number of test data with the Data Generator, including data for a column of the XMLTYPE? I wish to do this in order to test performance in different operations on XMLTYPE using CLOB vs OBJECT RELATIONAL storage. Helene
How can I generate a large number of test data with the Data Generator, including data for a column of the XMLTYPE? I wish to do this in order to test performance in different operations on XMLTYPE using CLOB vs OBJECT RELATIONAL storage. Helene
K kctx7 Member² Nov 19, 2004 #1 We had problems with XMLType columns and I ended up creating a view that implemented xmlcolumn.GetStringVal() for the xmlcolumn, then translated back using the XMLType constructor in an "INSTEAD OF" trigger.
We had problems with XMLType columns and I ended up creating a view that implemented xmlcolumn.GetStringVal() for the xmlcolumn, then translated back using the XMLType constructor in an "INSTEAD OF" trigger.