Question

oracle中这样创建存储过程对不，为什么执行时老是提示错误，说存储过程无效

create or replace procedure car_run
(in_car in car_behavior.car%type
)
as
out_startTime date;
out_endTime date;

begin
select dateutil.int2date(start_time),dateutil.int2date(end_time)
into out_startTime, out_endTime
from car_behavior
where car=in_car and btype='I';
dbms_output.put_line('startTime:'||out_startTime);
dbms_output.put_line('endTime:'||out_endTime);
end car_run;

begin
car_run(3602);
end;

Answer 1

select dateutil.int2date(start_time),dateutil.int2date(end_time)
into out_startTime, out_endTime
from car_behavior
where car=in_car and btype='I';

这里有问题 你试试
execute immediate 'select dateutil.int2date(start_time),dateutil.int2date(end_time)
into out_startTime, out_endTime
from car_behavior
where car='||in_car||' and btype=''I'' ';