在存储过程中做简单动态查询代码

2/9/2008来源:Oracle教程人气:9741


  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;