rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Nov 1st, 2006

 

The scope of A cursor declared in a procedure is limited to that procedure only.

The Scope of cursor declared in a package specification is global .

Example:

create or replace package curpack is

cursor c1 is select * from emp;

end curpack;

This will create a package Now You can use this cursor any where. Like:

set serveroutput on

begin

for r1 in curpack.c1 loop

dbms_output.put_line(r1.empno||'  '||r1.ename);

end loop;

end;

this will dispaly all empno and enames.

It will be better to use ref cursor in packages

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 13th, 2007

 

if we declare in package body then what is difference b/w cusrsor..........?how many types of refcursors..............?whata re the advantages of ref cursors....................?

divyesh

• Oct 13th, 2007

 

Ref cursors are used when you want cursor to hold any no. of columns in the row.

If you are not sure about row type at complile time you use ref cursors.

Sys_ref_cursors used when you want cursors to be passed from one procedures to another procedures or functions.