Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA 1403 NO DATA with select statment

ORA 1403 NO DATA with select statment

From: Antony Ma <antony_ma_at_hotmail.com>
Date: Wed, 24 Feb 1999 11:23:58 +0800
Message-ID: <36D370CD.4D3A2476@hotmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US