Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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