Your script works fine except because the second record does not have a Hostel facility field, it uses the data from the previous record

c:\Temp\perlmonks>perl 919135.pl
Inserting "BOYS 120 2 5 available"
Inserting "GIRLS 300 3 10 available"
[download]

Just need to clear the @record after the execute with

@record=();
[download]

poj