Dear all,

I have created a function for a database that compares the

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.

Hi-

Thank you anacedent for your kind words. Since I wrote the previous post, I have changed my trigger code a bit was able to create the trigger. So I'll close this thread.

jm1