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

---

CATALOGMANAGER.deleterows

Deletes multiple rows in a table using the CATALOGMANAGER command.

Syntax

<CATALOGMANAGER>
<ARGUMENT NAME="ftcmd" VALUE="deleterows" />
<ARGUMENT NAME="tablename" VALUE="table" />
<ARGUMENT NAME="primarykeyN" VALUE="keyvalue"/>
[<ARGUMENT NAME="Delete uploaded file(s)" VALUE="yes|no"/>]
</CATALOGMANAGER>   

Parameters

ftcmd (required)

Values must be set to deleterows.

tablename (required)

Name of the table containing the rows to delete.

primarykeyN (required)

Value of row's primary key. The primarykey parameter is the primary key's column name. The value of N corresponds to the row number--in the resultset--that you want to delete.

Delete uploaded file(s)(optional)

Value should be set to yes if upload files associated with row should be deleted. Default is no.

Description

The deleterows command deletes rows in a table. You can also delete uploaded files.

Error Numbers

The possible values of errno include:

Value	Description
-105	Database error.

Example

The following example deletes two rows from the TopMovies table:

id	director	title
133	charlie chaplin	modern times
137	buster keaton	the general
145	clint eastwood	a perfect world
148	rob reiner	the princess bride

To delete two rows from this table, use the following code:

<SETVAR NAME="errno" VALUE="0"/>
<CATALOGMANAGER>
   <ARGUMENT NAME="ftcmd" VALUE="deleterows"/>
   <ARGUMENT NAME="tablename" VALUE="TopMovies"/>
   <ARGUMENT NAME="id0" VALUE="137"/>
   <ARGUMENT NAME="id1" VALUE="145"/>
</CATALOGMANAGER>
<IF COND="IsError.Variables.errno=true">
	 	 <THEN>
	 	 <!--Handle error-->
	 	 </THEN>
</IF>

See Also

deleterow

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