Hi,

I have a table that I want to represent as a Perl-object via Class::DBI.

The table (in Oracle) looks like this:

create table ringo (
   id int primary key,
   john varchar2(100),
   paul XmlType
)
[download]

So one of the columns has XmlType and I want that column to be inflated as an object of itself.

The problem now is that in order to retrieve the xml stored in the "paul"-attribute I have to use a ORA_XMLTYPE (here are some details) and I can't see how to incorporate that into Class::DBI without supplying the whole SQL myself.

So my question is this:

Is there a way to retrieve the XML in the paul-column and use it to inflate the column to an object of it's own without doing everything myself?

Many thanks!