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

Hello, bert,

near 07:15 16-Jul from bertholomaeus_at_yahoo.ca:

> 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?

include theis statement in block with exception handler section.

-- 
wbr,
Wit.