Subject Detecting which FK has been violated within a SP
Author Adam
Hi Group,

Simple question that I cant think of the answer. I have a stored
procedure that does a simple insert

insert into mytable (a,b,c) values (1,2,3);

I want to catch foreign key violations in a when ... do block. But I
need to know which of the foreign keys has been violated. Is there a
way to do this?

Adam