First of all, a helpful hint about posting successfully: narrow down the problem you're having as tightly as possible. Demonstrate the trouble and explain the results of your attempts as succinctly as you can, and please provide references to helpful material, such as this article. According to the documentation, your call to ct_sql will return an array of references to rows, perhaps something like this:

my @array = ([1,2], [3,4], [5,6]);
[download]

So it seems like your implementation in systemNames should work:

@rows = $dbAdo->ct_sql($sql);
  foreach $row (@rows) {
    $main::systemNames{$row->[0]} = $row->[1];
}
[download]

What (wrong) behavior are you seeing when you do this?

Once you've got that working with a foreach loop, you might try map for a nicer solution:

my %hash = map { $$_[0] => $$_[1] } @array;
[download]

Where map runs through each element of @array, setting $_ each iteration to the current element (an array reference), which you can then dereference and pull apart before inserting the results into a hash.