自己写个dbms_lock.sleep函数

create or replace procedure sp_dbms_lock(p number)
is
  v_send number := p;
  v_begin_date date :=sysdate;
begin
  while v_begin_date + v_send / (1440 * 60) > sysdate
  loop
    if v_begin_date + v_send / (1440 * 60) < sysdate then
      return;
    end if;
  end loop;
end sp_dbms_lock;