setUpdateColumn Procedure

This procedure adds a column to the update column list. In the case of an insert, the default is to insert values in all the columns in the table. In case of updates, the default is to update only the columns corresponding to the tags present in the ROW element of the XML document. When the update column list is specified, only the columns making up this list will be updated or inserted into.

Syntax

DBMS_XMLSAVE.setUpdateColumn (

ctxHdl   IN ctxType, 
colName  IN VARCHAR2);

Parameters

Table 73-9 shows the parameters of the setUpdateColumn procedure.

Table 73-9 setUpdateColumn Procedure Parameters

Parameter	Description
ctxHdl (IN)	The context handle.
colName (IN)	The column to be added to the update column list.