create or replace procedure test(count1 in number,date1 in date) is
begin
select sysdate+interval ''count1'' hour
into date1
from dual;
execute immediate sqltemp;
end test;
我怎么都不能编译,为什么我的参数不能输入进去 ?
begin
select sysdate+interval ''count1'' hour
into date1
from dual;
execute immediate sqltemp;
end test;
我怎么都不能编译,为什么我的参数不能输入进去 ?
然后声明一个变量sqltemp varchar2(1000);
sqltemp := 'select sysdate+interval ''' || to_char(count1) || ''' hour from dual';
execute immediate sqltemp into date1;