Member Avatar for sk8ergirl

I've been trying to delete row in my database and all I get is this error

ORA-04084: cannot change NEW values for this trigger type
ORA-06512: at "myDB.STUDENT_ID_TRIGGER", line 4
ORA-04088: error during execution of trigger 'myDB.STUDENT_ID_TRIGGER'

DELETE FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street'
  • 2 Contributors
  • 1 Reply
  • 152 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by rch1231
Member Avatar for rch1231

Just out of curiosity have you run the select query to see what records you are attemptng to delete? It could be your delete is pulling more than on record.

SELECT * FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street'

But with that said the problem seems to be the STUDENT_ID_TRIGGER is trying to update values it cannot write to. I would take a look at the trigger to see if it is an update trigger that should be an insert trigger.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.