-
ORA-01422: exact fetch returns more.........
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!
Hemant
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|