create or replace trigger NEW_ALM_REMIND
after insert on tspfi_alm_info_active
for each row
declare
-- local variables here
begin
if :new.alm_clr_time is null then
exec DBMS_LOCK.sleep(500);
NEW_ALM_REMIND_SMPRO;
end if;
end NEW_ALM_REMIND;
----------------------Error: PLS-00103: 出现符号 "DBMS_LOCK"在需要下列之一时:
:=.(@%;
符号 ":=" 被替换为 "DBMS_LOCK" 后继续。
Line: 9
Text: exec DBMS_LOCK.sleep(500);
after insert on tspfi_alm_info_active
for each row
declare
-- local variables here
begin
if :new.alm_clr_time is null then
exec DBMS_LOCK.sleep(500);
NEW_ALM_REMIND_SMPRO;
end if;
end NEW_ALM_REMIND;
----------------------Error: PLS-00103: 出现符号 "DBMS_LOCK"在需要下列之一时:
:=.(@%;
符号 ":=" 被替换为 "DBMS_LOCK" 后继续。
Line: 9
Text: exec DBMS_LOCK.sleep(500);
after insert on tspfi_alm_info_active
for each row
declare
-- local variables here
begin
if :new.alm_clr_time is null then
DBMS_LOCK.sleep(500);
NEW_ALM_REMIND_SMPRO;
end if;
end NEW_ALM_REMIND;