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...
i think u r using some select *** into lv_var from table_name;
here is the problem
i think i hv helped u
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.
CURSOR cursor_name IS Select ... ;
FETCH cursor_name INTO var1, var2, ....
generally that error occurs due to the select statement returns more than one value.
means if u issue SELECT INTO 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 DISTINCT INTO from
or using cursors.