create procedure proc_update_type
AS
begin
update t_train_place set place_type = 2 where rent_end_date < sysdate;
end;
exec proc_update_type;
创建存储过程之后,不能成功调用,而且会报错,我想知道为啥出错了,有哪位大神能告诉我,谢谢!
create procedure proc_update_type
AS
begin
update t_train_place set place_type = 2 where rent_end_date < sysdate;
end;
exec proc_update_type;
创建存储过程之后,不能成功调用,而且会报错,我想知道为啥出错了,有哪位大神能告诉我,谢谢!