在存储过程中做简单动态查询代码

CREATE OR REPLACE procedure ZXM_SB_GZ_GET

(p_table in varchar2,

p_name in varchar2,

p_value in varchar2,

outpara out lntxdba.zxm_pag_cs_power.c_type

)

as

begin

declare

wherevalue varchar2(200);

begin

wherevalue:=select * from ||p_table|| where ||p_name||=||p_value;

open outpara for

wherevalue;

end;

end;