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;