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.

1) It is not necesary to DROP the trigger if you have a "CREATE OR REPLACE..."

2) You cannot do DML on the same table of the trigger.

:rolleyes:

Thank you for the quick responce. I will get rid of the drop. however I am not doing a DML on the same table as the trigger. The trigger is executing after an insert on the PICTURE table and it is inserting into the PICTUREAUD table.

It would help if post provides full session log.

Either way, please try...
vOsUser := USERENV('OS_USER');
... instead of...
select SYS_CONTEXT('USERENV','OS_USER') into vOsUser from dual;

PAVB,
I tried repolacing the line of code you mentioned with your suggestion and went to compile it again and got the same error. I can provide a session log if someone lets me know how to do that.

Quote:

---

Originally Posted by jayjabour

I can provide a session log if someone lets me know how to do that.

---

For short logs use copy/paste - for long ones use Attach feature, "Go Advanced" and click on attach button.

"For short logs use copy/paste - for long ones use Attach feature, "Go Advanced" and click on attach button." I am not sure what utility you are using that has those options.

You are not posting all the error messages, are you?
:rolleyes:

Quote:

---

Originally Posted by jayjabour

"For short logs use copy/paste - for long ones use Attach feature, "Go Advanced" and click on attach button." I am not sure what utility you are using that has those options.

---

are you referring to copy/paste? :D
on the other hand "Go Advanced" is the nice button on the bottom-right of the screen you use to post :cool:

OK, I guess we are not talking about the same thing. My mistake sorry. When I asked someone to tell me how to supply a session log I ment how to I get a session log. once I get the log I now how to attach it or copy and paste :) What I am not sure on is other then spooling my session to a file how would I get you a session log?

AGAIN:

Quote:

---

Originally Posted by LKBrwn_DBA

You are not posting all the error messages, are you?
:rolleyes:

---

The error you posted is not an isolated error but it complements other error messages.

POST ALL the error messsages...
:p

I appologize looks like there was another part to the error. here is the entire thing. Sorry but this is all i get.
PL/SQL: ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-320: the declaration of the type of this expression is incomplete or malformed

For one thing, the following looks suspicious if you are NOT forcing mixed case column names:

PHP Code:

---

:NEW."Patient", 


---

if this is the case, try removing the double quotes.
;)

LKBrwn_dba,
thanks for the push in the right direction. I figured out my poroblem. It wasn't with the new."Patient" part but close. I created a table that the trigger was populating and one of the fields was DATE. I found something on the internet that referenced the database using mixed case on the fields and having a field called DATE. I recreated the table changing the DATE field to ADATE and the trigger works great. I am not sure why the fields in this schema are mixed case. It is driving me nuts. I am new to being an oracle DBA full time and have never seen a database where the case of the fields was like that. I just started here 2 months ago and it is driving me crazy.