I'm getting following error messages..what should I look for?
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "RPIDB.RPI_MISC", line 690
ORA-06512: at "RPIDB.RPI_ARMY", line 393
ORA-06512: at line 20
both RPI_MISC and RPI_ARMY are Procedures...
Thanks.
hi,
i think u r using some select *** into lv_var from table_name;
here is the problem
i think i hv helped u
thnx,
yes..I'm using select...into......
what's my option to solve this problem?
write a query that returns one row. you can do this by running the query in SQLPlus without the into part of the query and see how many rows are returned. You can also add the distinct word to the clause.
If you need further help post the query.
Use a Cursor.
DECLARE
CURSOR cursor_name IS Select ... ;
var1 ...
var2 ...
BEGIN
OPEN cursor_name;
LOOP
FETCH cursor_name INTO var1, var2, ....
.
.
.
END LOOP;
CLOSE cursor_name;
END;
F.
generally that error occurs due to the select statement returns more than one value.
means if u issue SELECTINTO from ...............
so every variable can hold only one value at a time.
so that if that select statment returns more than one value, then system doesn't understood which value should be stored in that variable.
thats why the error occured.
so u can try that using
SELECT DISTINCTINTO from ...............
or using cursors.
Vth pleasure...
Bhaskar Akkala.............
