0 - 2 of 2 tags for Result Set

I am trying to pass a result set of a query into a procedure. I  only need one column from a table but the column will have multiple rows.
I have tried within the procedure to have : SELECT columnname INTO :variable from dbc.tablename where columnname2 = 'value';