hi i have the following trigger
create or replace trigger emp_sub
before insert
on employee
for each row
nRow department%ROWTYPE;
lnRow2 jobs %ROWTYPE;
lnCount NUMBER:=-1;
lnSin varchar2(20);
vempid number;
declare
SELECT COUNT (*)
INTO lnCount
FROM employee a,
(SELECT *
FROM XMLTABLE ('/message'
PASSING :NEW.MESSAGE
COLUMNS "empid" VARCHAR2 (4) PATH 'empid')) b
WHERE A.empid = vempid ;
if lnCount = 0 then
p_lsg := 'Record not found';
return;
end if;
end;
am geting this error ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword