Your variables are confusing. I can't tell if $subs_rst is global, and is thus the same one being used in the sub and outside of it. If so, you're clobbering the statement handle in the sub with the return value of execute.

First thing I'd suggest is to use strict so you can tell if you're blowing away something....