Home -> Usenet -> comp.databases.oracle -> SQL-Proceudre: SELECT ... INTO... within a while loop - doesnīt work

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

From: bert <bertholomaeus_at_yahoo.ca>
Date: 16 Jul 2004 07:15:57 -0700
Message-ID: <ea3b40c.0407160615.253a680c_at_posting.google.com> 





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 - 16:15:57 CEST












Original text of this message