一个很简单的存储过程
create or replace procedure proc_copy(years in bd_jobtype.jobtypecode%type,pk_corps in bd_jobtype.pk_corp%type
,typename in bd_jobtype.jobtypename%type)
is
begin
insert into bd_jobtype(jobclclass,jobphaseflag,jobtypecode,jobtypename,pk_corp,pk_jobtype)
select bd_jobtype.jobclclass,'N' as jobphaseflag,to_char(to_number(years)+1) as jobtypecode
,typename as jobtypename, pk_corps as pk_corp,generatepk(pk_corps) as pk_jobtype
from bd_jobtype where jobtypecode=pk_corps;
commit;
end;
传入years,pk_corps,typename三个变量,执行insert into target_table(column1,column2) select column1,2 from source_table这个语句,我把这条语句拿出来自已给他加变量正常,但存储过程执行了,数据没变化,这是怎么回事呢
create or replace procedure proc_copy(years in bd_jobtype.jobtypecode%type,pk_corps in bd_jobtype.pk_corp%type
,typename in bd_jobtype.jobtypename%type)
is
begin
insert into bd_jobtype(jobclclass,jobphaseflag,jobtypecode,jobtypename,pk_corp,pk_jobtype)
select bd_jobtype.jobclclass,'N' as jobphaseflag,to_char(to_number(years)+1) as jobtypecode
,typename as jobtypename, pk_corps as pk_corp,generatepk(pk_corps) as pk_jobtype
from bd_jobtype where jobtypecode=pk_corps;
commit;
end;
传入years,pk_corps,typename三个变量,执行insert into target_table(column1,column2) select column1,2 from source_table这个语句,我把这条语句拿出来自已给他加变量正常,但存储过程执行了,数据没变化,这是怎么回事呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货