|
CREATE OR REPLACE procedure ZXM_SB_GZ_GET (p_table in varchar p_name in varchar p_value in varchar outpara out lntxdbazxm_pag_cs_powerc_type ) as begin declare wherevalue varchar(); begin wherevalue:=select * from ||p_table|| where ||p_name||=||p_value; open outpara for wherevalue; end; end; |
