while (@array) 
{
    my $info_element = shift @array;

    $sql= "SELECT C58XX.CCLMyy, C58XX.CLINyy FROM C58XX
           WHERE C58XX.CCLMyy=$info_element AND 
           C58XX.CLINyy=$X_LINE ";
    ....
}