Hi Gurus,

I get the error message

ORA-01422: exact fetch returns more than requested number of rows

on the following proc...

CREATE OR REPLACE procedure test_dyn2(
v_id_in in number) is
cursor c100 is
select id,quote_id from test_dyn;
v_id number;
v_quote_id varchar2(50);
begin
for currec in c100
loop
if v_id_in > currec.id then
insert into test_dyn_hold(id,quote_id) select id,
quote_id from test_dyn where id > v_id_in;
end if;
end loop;
end;
/


I need to populate the test_dyn_hold table with all the records from test_dyn where the id > IN parameter id.

How would I do this???

Thanks!