what is wrong with this code? [message #211441] |
Thu, 28 December 2006 13:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jewelthief
Messages: 2 Registered: December 2006
|
Junior Member |
|
|
DECLARE
htree ITEM;
node_value VARCHAR2(100);
abc number;
BEGIN
htree := Find_Item('tree1');
node_value:=Ftree.Get_Tree_Node_Property(htree, :SYSTEM.TRIGGER_NODE, Ftree.node_value );
set_block_property('TOPICS',default_where,'topic_id=node_value');
go_block('TOPICS');
execute_query;
if error_code=40505 then
set_alert_property('alert',alert_message_text,DBMS_ERROR_TEXT);
abc:=show_alert('alert');
end if;
END;
i have written this code in when-tree-node-selected trigger but it is giving me error that
"NODE_VALUE" invalid identifier.
|
|
|
|
|