create or replace procedure aaaa (ziduan in varchar2,
biaoming in varchar2,
customerId in varchar2,
name1)is
v_sql varchar2(200);
v_fields varchar2(20);
fieldvarchar2(20);
field1varchar2(20);
v_1:='aaaaa';
v_2:='bbbb';
begin
v_sql:='select field:=ziduan from field1:=aaa where id=:customerId and name=:name1;
execute immediate v_sql into v_fieldsusing v_1 ,v_2;
end aaaa;