[Dbix-class] Oracle xmltype

Ronald J Kimball rkimball+dbixclass at pangeamedia.com
Tue May 5 16:27:02 GMT 2009


Morgon Hed wrote:
>> You can set '+select' and '+as', and stick that in a
>> resultset method, so
>> the code just becomes
>>
>> $stream_rs->with_xml_field->...
> 
> Thanks for the reply but I don't quite understand what you are saying.
> 
> I can easily do the follwing:
> 
> my $s1 = $schema->resultset('Stream')->search(
>                                                {},
>                                                    {
>                                                      select => [ 'another_col', { 'xmltype.getCLobVal' => 'xml' } ],
>                                                      as     => [qw/another_col xml/],
>                                                    }
>                                              );
> 
> Then I can of course retrieve more columns - why would I want to use '+select' (which is not even mentioned in the  DBIx::Class::ResultSet pod)?

It certainly is mentioned in the DBIx::Class::ResultSet documentation:

http://search.cpan.org/~ribasushi/DBIx-Class-0.08102/lib/DBIx/Class/ResultSet.pm#+select

Ronald



More information about the DBIx-Class mailing list