Table mutating error in Oracle

Good Morning world,

Ok, I have to write an Oracle trigger in which I need to do a Select on the table a new record is being added to. I need to get the max value of a column and compare it with the value for that column for the new record.

But running it gives a table mutating error, which makes sense because you are trying to get a value from the table that is being modified at that point. Of course I could move the logic out to the Java class, but in what other way can it be done in the database?

Use package variable. Docs also say you can use a PL/SQL-Table or a temporary table but I think first one is the easiest. Search the web. There should be some simle examples out there.

Thanks Vladan.