Skip to content
Advertisement

Oracle SQL Trigger not getting created

I have a table passenger as shown below

I am learning triggers and I want to create a trigger that updates charges as charges + 100 before a new insert is done. Here is the trigger I created.

However, I am getting the error ORA-04079: invalid trigger specification. I have tried replacing new with :new, adding begin & end blocks, but none of them seem to work.

Advertisement

Answer

Invalid syntax.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement