From: @   
      
   your WHILE loop never executes   
      
   -- mcs   
      
   "Jeremy Moncho"  wrote in message   
   news:BBF542FD.14A4%jeremy.moncho@bluewin.ch...   
   | Hi guys,   
   |   
   | I am having a comprehension problem for which I cannot seem to find an   
   | answer (by banging my head on my keyboard.)   
   |   
   | I have the following code which yields no results. I expect one result to   
   | come out of it as I am using a while loop on a cursor set to retrieve one   
   | single tuple.   
   |   
   | Please be nice, it is my first day seeing cursors ;-)   
   |   
   | Tia,   
   |   
   | jeremy   
   |   
   |   
   | CREATE TABLE people(   
   |     id int,   
   |     fname VARCHAR2(20),   
   |     lname VARCHAR2(20)   
   | );   
   |   
   | insert into people values (0, 'lois', 'lane');   
   | insert into people values (1, 'clark', 'kent');   
   | insert into people values (2, 'jimmy', 'olsen');   
   |   
   | set serveroutput on;   
   |   
   |   
   | CREATE OR REPLACE PROCEDURE show(curr_id INT)   
   | AS   
   |     CURSOR curr_in IS SELECT fname, lname FROM people WHERE id=curr_id;   
   |     curr_fname VARCHAR2(20) := null;   
   |     curr_lname VARCHAR2(20) := null;   
   |   
   | BEGIN   
   |     OPEN curr_in;   
   |   
   |     while curr_in%found loop   
   |         FETCH curr_in INTO curr_fname, curr_lname;   
   |         dbms_output.put_line('done');   
   |         dbms_output.put_line(curr_fname || ' ' || curr_lname);   
   |     end loop;   
   |   
   |     CLOSE curr_in;   
   |   
   | EXCEPTION   
   |     WHEN OTHERS THEN   
   |         dbms_output.put_line(sqlcode || ' ' || sqlerrm);   
   | END;   
   |   
   | /   
   |   
   |   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)