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

    How to fetch columns in cursor using FETCH?

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

      CURSOR c1 IS

      select Name,Rollno,Section from emp;

      BEGIN

      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