How do we come to know that we have reached the end of record in a cursor for loop.
For example, i have this PL/SQL block:

DECLARE
   CURSOR c1 IS
      SELECT sal FROM emp;
   SALARY_TOTAL NUMBER:=0;
BEGIN
   FOR emp_rec IN c1 LOOP
      salary_total := salary_total + emp_rec.sal;
      ---dbms_output.put_line(salary_total);
   END LOOP;
END;

And i want to output the total salary when the FOR LOOP reaches the end of the record,how am i going to determine that we have reached the end of the record.


MAXOOD!

Life is an endless journey towards perfection

Hi,

When using cursors, you can use the following code:
WHEN cursor_name%NOTFOUND ...

I used this to exit a loop at the end of the cursor in the following script: http://geertverhoeven.blogspot.com/2...rns-table.html
Greetz,

Geert

http://geertverhoeven.blogspot.com

hi,

u didnt mention whether u r getting any error msg or result is not displayed. ur code looks fine, if output is not returned then check ur server output by...
if its off then turn it on by..

__________________
Akhil