Data generator and XMLTYPE columns

Helene

Member³
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
 
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.
 
Back
Top