请楼主看清楚 select max(up_time) into max_time from tb_a where waybill=waybill 这样语句有什么意义,where waybill=waybill 还是把所有语句全选出来 把过程修改如下: create or replace procedure pr_out_item_delete (p_waybill in varchar2,corp_id in varchar2,max_time out date) as str1 varchar2(400); --max_time date; ls_waybill varchar2(20); begin pr_add_yh(waybill,ls_waybill); select max(up_time) into max_time from tb_a where waybill=p_ls_waybill; end;
select max(up_time) into max_time from tb_a where waybill=waybill
这样语句有什么意义,where waybill=waybill 还是把所有语句全选出来
把过程修改如下:
create or replace procedure pr_out_item_delete
(p_waybill in varchar2,corp_id in varchar2,max_time out date)
as
str1 varchar2(400);
--max_time date;
ls_waybill varchar2(20);
begin
pr_add_yh(waybill,ls_waybill);
select max(up_time) into max_time from tb_a where waybill=p_ls_waybill;
end;