compilation unit analysis terminated error when compiling a trigger
I created a trigger to execute when someone inserts a row into a table. when I went to compile the trigger after creating it I get the following error:
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
It is pointing to line 6. here is the trigger:
DROP TRIGGER AXIUM.PICTURETRG;
CREATE OR REPLACE TRIGGER AXIUM.PICTURETRG
AFTER INSERT
ON AXIUM.PICTURE REFERENCING NEW AS NEW
FOR EACH ROW
DECLARE
vOsUser VARCHAR2(64);
BEGIN
select SYS_CONTEXT('USERENV','OS_USER') into vOsUser from dual;
INSERT INTO AXIUM.PICTUREAUD VALUES (
:NEW."Patient",
vOsUser,
sysdate);
END;
/
Any help would be greatly appreciated. Thank you.