Originally posted by cheers
hi all, if my stored procedure is returning more than 1 record.. how should i increase my fetch?
When too_many_rows then
????---> what should I put?
TOO_MANY_ROWS is raised when you use SELECT...INTO and it returns more than 1 row. SELECT...INTO should only be used where 1 row is expected. If you want to return more than one row you would normally use a cursor. Or you could use BULK COLLECT INTO with PL/SQL tables to get multiple rows.