存储过程实例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;