Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 1403 NO DATA with select statment
Antony Ma 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;
>
> 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
Are you declare c1 as table%rowtype? ("table" is pseudonim - yes?) Received on Wed Feb 24 1999 - 08:33:02 CST