From: wit_no@spam_dba.kiev.ua   
      
   Hello, bert,   
      
   near 07:15 16-Jul from bertholomaeus@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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)