If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

thanks for the push in the right direction

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.