Need to return more than one row!

[hemanr]

Hi Gurus,

CREATE OR REPLACE procedure ppqt_test_dyn2
(v_id in number) is
v_quote_id varchar2(50);
begin
select quote_id into v_quote_id from test_dyn where id = v_id ;
dbms_output.put_line(v_quote_id);
end ppqt_test_dyn1;

This works perfectly since I have the condition as

id = v_id;

But if I give id > v_id, the result fetches more than one record.

How do I handle this?

Can anyone help me with the syntax?

Thanks!