Subject | Detecting which FK has been violated within a SP |
---|---|
Author | Adam |
Post date | 2006-02-15T04:16:26Z |
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
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