Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to make use of the data in a cursor returned from a stored

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

From: jim mcnamara <jmcnamar_at_swcp.com>
Date: 1 Aug 2002 09:55:44 -0700
Message-ID: <19b60539.0208010855.53d156c9@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US