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



Updates field values for a row in a table using the CATALOGMANAGER command.


errno is not set. No error is generated if the value for a particular column is invalid (for example, enter a text character into an integer type field). Valid column edits succeed, invalid column edits do not. We recommend that you check your input carefully.



ftcmd (required)
Value must be set to updaterow.

tablename (required)
Name of the table containing the row to be updated.

primarykey (optional)
Value of row's primary key. The primarykey parameter is the primary key's column name.

columnname (optional)
Each column in the row to be modified. columnname is a table column name.

urlcolumnname_folder (optional)
A subfolder name to store the uploaded file. The file is then stored under the upload folder and the subfolder. The upload folder is specified in the SystemInfo table's defdir column. Note that you can have multiple upload columns.

columnname_file (required for non-binary files)
The name of the file you want to upload. The column name in the table must begin with url (for example, urltext). The argument name must have _file appended to the table's column name (for example, urltext_file).

tablekey (optional)
Use the tablekey parameter if you want to update rows based on a value other than the primary key. The value of tablekey is the column name of the column you use to perform the update. For example, if you want to update a table based on the value in the title column, the tablekey parameter looks as follows:

tablekeyvalue (optional)
Value in the tablekey column of the row you want to update. For example, if you want to update a row with a value of Jaws in the title column, the tablekeyvalue parameter looks as follows:


The updaterow command updates field values for a row in a table. For each column and specified value, the existing column value is replaced with the incoming data for that column. Only values specified are changed; you cannot clear a value in a table row or column by using editrows or updaterows. You must use replacerow or updaterow2 .

Error Numbers

The possible values of errno include:

No such table.
No table definition.
Database error.


The following example updates the description in the movies table for a given movie:

See Also


  Home > Contents > Index >

Oracle XML Tag Reference
Copyright (c) 2013, 2019, Oracle and/or its affiliates. All rights reserved.