Deepika S Verma

• Mar 10th, 2014

Ref Cursors are used in two conditions
(1) When we have a dynamic query, means when we get the information at runtime related to query(like column name, table name etc)
(2) Or when we want to pass whole resultset to another proc/func.

suresh reddi

• Aug 19th, 2011

Using ref cursor we can pass different values( i.e by changing parameters) to the cursor which is declared in the package specification from the package body. Ref cursors are of 2 types a) weak r...

Answer Question  Select Best Answer