oracle存储过程中出错？

[ponky]

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;
我怎么都不能编译，为什么我的参数不能输入进去 ?

[basten622]

date1看你需求应该是out类型。
然后声明一个变量sqltemp varchar2(1000);
sqltemp := 'select sysdate+interval ''' || to_char(count1) || ''' hour from dual';
execute immediate sqltemp into date1;