For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
I've seen several examples of the hierarchical tree in Forms but none of them handle adding, updating or deleting nodes in the tree. Does anyone know where I can find example that handles DML using a tree item?
If you want to adding, updating or deleting tree nodes then you can use the when-Tree-Node-Selected trigger with
a pop-up menu having Insert, Update or Delete tree node
For INSERT you can write manually insert statement in your forms and after inserting the new node refresh your tree.
For DELETE write the delete statement for deleting the tree node and after deleting the existing node refresh your tree.
For UPDATE the tree node , assign your tree node details in another block and edit it and save it after save refresh the tree.
Check this links for your reference.
Oracle forms Hierarchical tree
OraFAQ Forum: Forms » Hierarchical Tree form
Hope it helps you.