HELP NEEDED Passing column name as a parameter in store procedure 1

[JawwadLone]

Below the is Oracle procedure:

PROCEDURE proc_BARRACKLookup
	(
		cur_out OUT cursor_type,
		p_query IN varchar2
	)
as 
sqlstatement varchar2(200):='open cur_out for select '||	p_query ||' from	employee';
	begin
  execute immediate  sqlstatement ;
	end;

i m trying to retrieve records by passing column of employee table in "p_query" parameter.problem i m having is that i dont know exactly how to assign the value to cursor in this scenario.

regards
Jawwad

 

[sem]

Ok, a bit better. I assume that your cursor_type is declared correctly.

PROCEDURE proc_BARRACKLookup
    (
        cur_out OUT cursor_type,
        p_query IN varchar2
    )
is
begin 
   open cur_out for 'select ' || p_query || ' from employee';

end;

Regards, Dima

http://seminihin.narod.ru

 

[JawwadLone]

thanx for ur help it worked