G's

I have built the trigger utilising the sequence, in theory I want the
trigger to use the sequence to update the primary key, this in theory to be
done before insert or update. Now when inserting I get an ORA-02291
integrity constrainty about the primary key.

I thought the trigger would use the sequence and insert into the primary
key and then the insert would take effect.

I am aware my understanding of it may be impaired.

Please let me know.

Luis


This communication is intended for the addressee(s) only.
Please notify the sender if received in error. Internet email
is not to be treated as a secure means of communication.
Cheshire Constabulary monitors all Internet and email activity
and requires it is used for official communications only. Thank
you for your co-operation.

Oracle LazyDBA home page