$sth = $dbh->prepare($query) or die "Prepare exceptioin: $DBI::errstr!";
   $rv = $sth->execute() or die "Execute exception: $DBI::errstr";
   $res = $sth->fetchall_arrayref();                    
   
   # Array reference with cols captions, which were retrived.
   $names = $sth->{NAME};          
   
   # Array reference with types of cols, which  were retrived                      
   $types = $sth->{TYPE};                               
   $sth->finish();