Re: ORA 1403 NO DATA with select statment

From: Graham Miller <igor001_at_hotmail.com>
Date: Sat, 27 Feb 1999 17:38:24 GMT
Message-ID: <36db2d05.38769422@news.u-net.com>

Antony Ma <antony_ma_at_hotmail.com> wrote (in <36D370CD.4D3A2476_at_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

Was the procedure compiled in a user with a local of the "table" which was empty?

Compiled procedures resolve all object references at compile time.

Just a suggestion.

graham Received on Sat Feb 27 1999 - 11:38:24 CST