I need some guidance dealing with complex XML structures like the one
below. My code below does not give the desired results. 
use DBI;
my $dbh = DBI->connect('dbi:AnyData(RaiseError=>1):');

$dbh->func(
          'catalog', #alias
          'XML', #format of input
          'catalog.xml', #source
 {col_names=>'product,catalog_item,item_number,price,size,color_swatch
+'},
          'ad_catalog' #
         );

my $sth = $dbh->prepare("SELECT * FROM catalog");

$sth->execute();

while (my $row = $sth->fetch) {
       print "@$row  \n";
         }

[download]

produces the following result:
cardigan.jpg Cardigan Sweater
QWZ567139.95RedBurgundyRedBurgundyRRX985642.50RedNavyBurgundyRedNavyBurgundyBlackNavyBlackBurgundyBlack
QWZ567139.95RedBurgundyRedBurgundy
RRX985642.50RedNavyBurgundyRedNavyBurgundyBlackNavyBlackBurgundyBlack
catalog.xml 
<?xml version="1.0"?>
<?xml-stylesheet href="catalog.xsl" type="text/xsl"?>
<!--<!DOCTYPE catalog SYSTEM "catalog.dtd">-->
<catalog>
  <product description="Cardigan Sweater"
product_image="cardigan.jpg">
     <catalog_item gender="Men's">
        <item_number>QWZ5671</item_number>
        <price>39.95</price>
        <size description="Medium">
           <color_swatch image="red_cardigan.jpg">Red</color_swatch>
           <color_swatch image="burgundy_cardigan.jpg">Burgundy</
color_swatch>
        </size>
        <size description="Large">
           <color_swatch image="red_cardigan.jpg">Red</color_swatch>
           <color_swatch image="burgundy_cardigan.jpg">Burgundy</
color_swatch>
        </size>
     </catalog_item>
     <catalog_item gender="Women's">
        <item_number>RRX9856</item_number>
        <price>42.50</price>
        <size description="Small">
           <color_swatch image="red_cardigan.jpg">Red</color_swatch>
           <color_swatch image="navy_cardigan.jpg">Navy</
color_swatch>
           <color_swatch image="burgundy_cardigan.jpg">Burgundy</
color_swatch>
        </size>
        <size description="Medium">
           <color_swatch image="red_cardigan.jpg">Red</color_swatch>
           <color_swatch image="navy_cardigan.jpg">Navy</
color_swatch>
           <color_swatch image="burgundy_cardigan.jpg">Burgundy</
color_swatch>
           <color_swatch image="black_cardigan.jpg">Black</
color_swatch>
        </size>
        <size description="Large">
           <color_swatch image="navy_cardigan.jpg">Navy</
color_swatch>
           <color_swatch image="black_cardigan.jpg">Black</
color_swatch>
        </size>
        <size description="Extra Large">
           <color_swatch image="burgundy_cardigan.jpg">Burgundy</
color_swatch>
           <color_swatch image="black_cardigan.jpg">Black</
color_swatch>
        </size>
     </catalog_item>
  </product>
</catalog>

[download]

In reply to DBD:AnyData on Complex XML by hmadhi

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.