oracle 存储过程 小例子

create or replace PROCEDURE CLICK_UPDATE
(
TABLENAME IN VARCHAR2
, T_ID IN NUMBER
) AS v_sql VARCHAR2(300);
BEGIN
v_sql:=’update ‘||tablename||’ set YDCS=YDCS+1 where ID=’||T_ID;
EXECUTE IMMEDIATE v_sql;
COMMIT;
END CLICK_UPDATE;