Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

Tony007Jan 23 2017 — edited Jan 23 2017

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2017
Added on Jan 23 2017
2 comments
3,690 views