How do I create a dynamic order by clause in a cursor?
leebeeryMar 28 2007 — edited Mar 28 2007I have the following in a form procedure.
I want to be able to pass in the column I want to sort this cursor by.
The following does not work, when it executes, it acts like it ignores the order by clause.
How do I get this to work?
It doesn't have to be in forms, it could be a db procedure, pkg, functon, etc.
declare
cursor c1(v_o in varchar2) is
select batch,
airport,
contract_no,
contract_descr,
contractor_name,
milestone_no,
milestone_descr,
sched_date,
frcst_act_date
from pc_milestones_cms
where print_rec = 'Y'
order by v_o;
v_order_by varchar2(500);
begin
open c1(v_order_by);
loop
fetch c1
into v_batch,
v_airport,
v_contract_no,
v_contract_descr,
v_contractor_name,
v_milestone_no,
v_milestone_descr,
v_sched_date,
v_frcst_act_date;
exit when c1%notfound;
.
.
.
end loop;
close c1;
end;