in reply to Class::DBI and Oracle XmlType
You'll have to play with it, but if you look in the source of Class::DBI you'll see some basic queries it uses that you can override in your class. That, combined with standard inflate/deflate code might be enough. Also, I suggest looking at examples on the Class::DBI wiki and possibly moving this question to the Class::DBI mailing list where there are more people who can help.
In Section
Seekers of Perl Wisdom