On Fri, 23 Sep 2005 21:37:36 +0200, paulbramble <pdbramble@...> wrote:

> I am having an intermittant problem with deletes.
>
> Our system runs under JBoss.
>
> I have a hierarchical structure of 11 tables. Because our product
> must run against multiple vendor's rdbms, I hard coded some of the
> deletes. I start deleting my tree from the bottom up. However,
> when I try to delete the topmost object, I get an error stating an
> integrety constraint on a foreign key is violated. (don't have the
> error code of the violation).
>
> I am sure everything has been deleted under the top level object.
> There are only 10 possible tables in which sub-tending data can
> reside, and I can see that all 10 deletes have been executed. And
> the data is gone.
>
> Any ideas as to what is going on?
>
> Thanks,
> Paul
>
>
>

Is it possible that you use this table in a stored procedure?

Because of stored procs use internal references.

br,
Karl