Home >	Contents >	Index >
Template Tag TOC  |   Alpha TOC  |   Tag Family TOC  |   Purpose TOC  |   Annotated TOC  |   Index

---

TREEMANAGER.getnode

Retrieves a node from a table. The object data may be joined to the result.

Syntax

<TREEMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="getnode/>
   <ARGUMENT NAME="treename" VALUE="name"/>
   <ARGUMENT NAME="node" VALUE="nodeid"/>
   [<ARGUMENT NAME="join" VALUE="true or false"/>]
   [<ARGUMENT NAME="depth" VALUE="depth setting"/>]
</TREEMANAGER>

Parameters

ftcmd (required)

Value must be set to getnode.

treename (required)

Name of the tree.

node (required)

ID of the node.

join (optional)

true or false to join the object table. Note that the object table holds the cache information.

depth (optional)

Defaults to 1. Limits the depth of recursion when scanning a tree. Illegal values are converted to 1. Specify -1 to remove depth restrictions on scan. Note below the impact of a deep recursive search. The depth parameter must be set to 1 if join is true.

Object tables that are joined to are required to be registered as type obj in the SystemInfo table in order to support the caching of resultsets that are created.

The name of the LIST constructed is stored in the value of the variables, treename (that is, Variables.treename).

errno

The possible values of errno include:

Value	Description
-3	No access privileges to table.
-3	No access privileges to table.
-103	No table.
-108	Node not input.
-110	Invalid tree name.

Example

<SETVAR NAME="errno" VALUE="0"/>
<TREEMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="getnode"/>
   <ARGUMENT NAME="treename" VALUE="TreetestTree2"/>
   <ARGUMENT NAME="join" VALUE="false"/>
   <ARGUMENT NAME=node" VALUE="Variables.setme"/>
</TREENAME>
<IF COND="IsError.Variables.errno=true">
    <THEN>
    <!--Handle error-->
    </THEN>
</IF>

See Also

findnode

		Home >	Contents >	Index >
	Oracle XML Tag Reference Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved.