I can't get a trigger to compile. What am I doing wrong?
I want to use a sequence to generate a Primary Key on a table. I want the trigger to fire BEFORE INSERT FOR EACH ROW and use the sequence.NEXTVAL as the value of the PR KEY.
What's the correct syntax please folks?
I'm using 8.1.5