存储过程实例5：存储过程执行truncate ，动态删除表，表明参数化

create or replace procedure clearPksTable(tableName in char)
 is
 v_sql  clob;
begin
  v_sql:= 'truncate table '||tableName||'';
  dbms_output.put_line(v_sql);
  execute immediate v_sql;
end clearPksTable;