post DDL for table DIAGNOSIS
Since we don't have your table or data, we can't run, test, or improve posted code.
post INSERT statements with sample test data.
>Oracle keeps giving syntax errors when I run the trigger..
ERROR? What Error? I don't see any error.