Re: How to make use of the data in a cursor returned from a stored

You FETCH first.

If the cursor returns three columns a,b,c then

v_a  VARCHAR2(10);  -- or whatever datatype
v_b  VARCHAR2(10;
v_b  VARCHAR2(10);   
.............................  after you call the procedure
LOOP
        FETCH cur INTO v_a, v_b, v_c;
        EXIT WHEN cur%NOTFOUND;
        DBMS_OUTPUT.PUT_LINE(v_a || v_b || v_c );
      

END LOOP; Received on Thu Aug 01 2002 - 11:55:44 CDT