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;