more ajax mem tree
520863Jun 29 2006 — edited Jun 30 2006Hi,
I am trying to make this article http://www.oracle.com/technology/pub/articles/spendolini-tree.html more Ajax.
My work is here http://htmldb.oracle.com/pls/otn/f?p=17761 .
But it has 2 bugs, i cant fix them. But important one is
cut/paste function:
simple usage: Click any emp from tree, click cut, click any manager (non-leaf employee), click paste.
problem: The employee which we move is "copied", not moved. But when I re-login, it seems as moved.
detail:
When click "cut" an app. level proc. and it calls this code:
----------------------------------------------------
ajax_memory_tree.change_manager(:P1_SOURCE, :P1_SELECTED_NODE);
commit;
----------------------------------------------------
code of change_manager is here:
-------------------- CHANGE_MANAGER
procedure change_manager ( p_id in varchar2, p_new_pid in number)
as
begin
update tree_view set pid = p_new_pid where id = p_id;
htp.prn('Update successfull.');
end change_manager;
------------------------------------------------
After doing this work "cut" calls reloads source and target nodes. These process are done by another app. level processes. But only write operation is done by code above.
I am a java programmer, new to ajax, oracle and apex. All comments and ideas are wellcome.