在ORACLE的存储过程中如何做简单的动态查询

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 )asbegin ;declarewherevalue varchar2(200);beginwherevalue:='select * from 'p_table' where 'p_name'='p_value;open outpara forwherevalue;end;end;