oracle 存储过程建表

create or replace procedure pro_scmcbs_mapping_table is
  icnt number := 0;
begin
  select count(*)
    into icnt
    from user_tables
   where table_name = 'TEMP_SCMCBS_MAPPING';
  if (icnt > 0) then
    execute immediate 'drop table temp_scmcbs_mapping';
  end if;
  execute immediate 'create table temp_scmcbs_mapping
  (
      costproject_code varchar2(40),
      costproject_name varchar2(300),
      pk_costprojectid varchar2(20) not null,
      projectclass_code varchar2(40),
      projectclass_name varchar2(300),
      pk_projectclass varchar2(20) not null,
      cbs_code varchar2(40),
      cbs_name varchar2(300),
      pk_cbsnode varchar2(20) 
      --not null
  )';
  execute immediate 'alter table temp_scmcbs_mapping add constraint pk_temp_scmcbs_mapping primary key (pk_costprojectid, pk_projectclass)';
end pro_scmcbs_mapping_table;