The idea here is that I am trying to build this array so I can then spin through the array and insert each of these rows into an Oracle table.

If your @dlr_loc array is really small, as you seem to suggest, you can supplement the array within the sql statement, if that seems appropriate:

my $ordtype = 'SEASONAL';
# ...
my $sql = "insert into that_table (a_col, b_col, c_col, d_col, e_col) 
+values (?,'US','M10','WEDNESDAY',?)";

my $sth = $dbh->prepare( $sql );

for my $a_val ( @dlr_loc ) {
    $sth->execute( $a_val, $ordtype );
}
[download]

Of course, if other fields turn out to be variables (and if you actually end up with a nested loop structure), that's fine -- just use more "?" placeholders in the sql statement.

OTOH, if you are going to be inserting a lot of rows (e.g. tens of thousands or more), your best bet is to use your perl script to create a tab-delimited text file containing the field values row-by-row (line-by-line), then invoke "sqlload" (or "sqlloader"?) -- the native Oracle data-import utility -- to actually load the contents of the file into the database. That will go a lot faster than using Perl/DBI to execute a long series of "insert into ..." statements (and the error-handling done by sqlload(er) will generally much better than you'd want to do yourself in Perl).