Home » Developer & Programmer » Reports & Discoverer » Whats more advantage in ref cursor than lexical parameter (Reports 6i)
Whats more advantage in ref cursor than lexical parameter [message #297475] Thu, 31 January 2008 22:22
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Dear Friends,

Can any one tell me Whats more advantage
in ref cursor than lexical parameter.

I am using Reports 6i.

In refcursor i am using. assuming P_1 is parameter name and i write code in after parameter form and my data model is created by ref cursor.
 p is ref cursor;
 p1 p;
 if :P_1 is null then
   open p1 for select * from emp;
 else if :p_1=7369
   open p1 for select * from emp where empno=7369;
 else
   open p1 for select * from emp where deptno=10;
end if;

 The above code is working depending 
upon parameters in run time.

I am asking about, i can able to do 
the above codes by lexical parameter also.

in my data model i am using select * from emp &p

p is lexical parameter, i can able 
to give a parameter at 
run time like this

 where empno=7369
 where deptno=10




So What exactly benifit for us from
using Ref cursor in reports.

Advance Thanks...

Mano






Previous Topic: EXPORT TO CSV
Next Topic: urgent 10g DS application Icon setting
Goto Forum:
  


Current Time: Wed Dec 07 11:05:25 CST 2016

Total time taken to generate the page: 0.17969 seconds