This discussion is archived
1 Reply Latest reply: Nov 2, 2012 9:48 PM by yoonas RSS

How to fetch columns in cursor using FETCH?

970843 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points