| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA 1403 NO DATA FOUND
A copy of this was sent to Antony Ma <antony_ma_at_hotmail.com>
(if that email address didn't require changing)
On Wed, 24 Feb 1999 11:26:12 +0800, you wrote:
>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;
>
that particular loop can NEVER raise a no data found (implicit cursor loops don't do that).
must be some logic INSIDE the loop. You either have a select ... into in there or you are using a pl/sql table and are referencing an empty cell.
lets see the code, all of it
> 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
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |