Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA 1403 NO DATA with select statment
HI,
I got a error with oracle 8. It was error 1403 (ORA-01403: no data
found) when I exececute a proceudre.
The procedure has these lines
FOR c1 IN ( SELECT * from table)
LOOP
......
END LOOP; When I enter "SELECT * from table" in SQL*PLUS, it returns all the rows.
The question is why it is NO DATA when the table contains 700 rows?
Thanks
Antony Received on Tue Feb 23 1999 - 21:23:58 CST