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;