1 Reply Latest reply: Nov 2, 2012 11:48 PM by yoonas RSS

    How to fetch columns in cursor using FETCH?

      create or replace PROCEDURE newprocedur(outname OUT VARCHAR2,outroll OUT NUMBER) AS

      CURSOR c1 IS

      select Name,Rollno,Section from emp;


      Open c1;

      fetch c1 into outname,outroll;

      Here out of 3 columns in cursor is it possible to fetch only two columns using FETCH like i did above??

      Edited by: im_asa on Nov 1, 2012 3:58 AM