Question: exit when notfound in oracle?
Answer: If FETCH never executes successfully, the EXIT WHEN condition is never TRUE and the loop is never exited. To be safe, you might want to use the following EXIT statement instead: EXIT WHEN c1%NOTFOUND OR c1%NOTFOUND IS NULL; You can use the cursor attributes in procedural statements but not in SQL statements.