on 2010 Apr 03 10:23 PM
When I try to delete a row in a table, I get an error!
"The selected row could not be delete. Prodcedure or tigger calls have nested too deeply"
Cheers!
Request clarification before answering.
This error occurs if there is a delete trigger on the table which causes another action - e.g. another insert, update, or delete - which causes another trigger or procedure to be called and that trigger/procedure causes another action to occur which causes another trigger/procedure to be called and that trigger/procedure causes another action to occur which .... etc, etc, etc ... until the nesting of calls to triggers or procedures is so deep that the database server go no longer processs the trigger/procedure call.
i.e. you have a run-away recursion in one of your (delete) triggers on the table.
For example, does your delete trigger attempt to delete another row in the same table? (which would then fire the trigger again!)
To resolve the problem, you need to first find the source of the recursion and then determine a way to stop the recursion before the nesting goes too deep.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
52 | |
10 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.