SQL-Proceudre: SELECT ... INTO... within a while loop - doesn´t work

Hi,

I want to insert the result of a select into a procedure-variable within a while-loop. The loop works as far as I don´t insert following line:

select tea.FDATE into ldTeaDate2 from ... tea where tea.ID = ldTeaId;

the error message:
ORA-01403: no data found
ORA-06512: at "...", line 70

The table and variables are created by the same user, who execute the statement.

Have anyone an idea? Received on Fri Jul 16 2004 - 09:15:57 CDT