hierarchy-data-closure-table icon indicating copy to clipboard operation
hierarchy-data-closure-table copied to clipboard

Published 20 hours ago • verified publisher icon developerworks

Getting error Can't update table 'prefix_nodes' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Open sushilshah opened this issue 8 years ago • 0 comments

Hi I am trying to follow the steps and delete a node

Hide or show nodes from subtree, explains as following:

Step 1. call p_get_tree(6) get the HARDWARE subtree, Step 2. call p_node_hide(6, 0) to hide a subtree, Step 3. call p_get_tree(6) get the HARDWARE subtree, when you get a subtree, it is not show in the result. Step 4. call p_node_hide(6, 1) show HARDWARE subtree

However, getting an error as ERROR 1442 (HY000): Can't update table 'prefix_nodes' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. error

Any help will be much appreciated.

sushilshah avatar Oct 17 '17 10:10 sushilshah