insert into select from 在存储过程里无效?????

[我叫P民]

一个很简单的存储过程
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这个语句，我把这条语句拿出来自已给他加变量正常，但存储过程执行了，数据没变化,这是怎么回事呢

[luoyoumou]

to_char(to_number(years)+1)

-- 怎么不再多用几个函数呢？

[luoyoumou]

[Quote=引用 1 楼 luoyoumou 的回复:]

to_char(to_number(years)+1)

-- 怎么不再多用几个函数呢？
[/Quote]

-- 表设计严重有问题

[我叫P民]

主要是根据今年创建出明年的,我把代码拷pl/sql developer里去，变量自已赋下值，都没问题的,但放存储过程里就没效，要怎么修改呢