I have two tables

Student
S_ID      PK
S_NAME

COURSE 
C_ID   PK
C_NAME
S_ID   FK

I've created trigger for both S_ID and C_ID (to generate id no insert update delete before each row )
when I do this

DELETE FROM STUDENT WHERE S_ID = 1

I get this

ORA-04084: cannot change NEW values for this trigger type
ORA-04088: error during execution of trigger 'myTables.S_ID_TRIGGER'

Recommended Answers

All 2 Replies

What does your trigger do? Doesn't it just need to run on an INSERT?

trigger is fiered when I insert delete or update it add unique id no

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.