Delete a row in a table error

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!

nested-too-deeply trigger recursion

asked 03 Apr '10, 21:23

Andrew
33●2●2●5
accept rate: 0%

edited 06 Apr '10, 13:25

Volker Barth
39.3k●355●539●809

Andrew... can you post details of your table and the related triggers?

(03 Apr '10, 22:34) Ron Hiner

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 03 Apr '10, 23:02

Mark Culp
24.7k●9●139●294
accept rate: 41%

As an addition to Mark's answer, I'd suggest that you take a look at the stored procedure debugger to help step through the process and figure out where it is going off the rails.

(07 Apr '10, 14:42) Rob Waywell

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

trigger ×77
recursion ×18
nested-too-deeply ×3

question asked: 03 Apr '10, 21:23

question was seen: 1,868 times

last updated: 06 Apr '10, 13:25

SAP SQL Anywhere

Delete a row in a table error

Follow this question

Related questions