UPDATE_SDATA

UPDATE_SDATA is an index API that modifies the specified SDATA values in the index. This API does not store or modify column values in a base table, where the base table column may have been used as an SDATA section.

Note: The UPDATE_SDATA API in Oracle Text is deprecated in Oracle AI Database 26ai.Instead of modifying the index, Oracle recommends that you update the underlying data.

Export/import operations rebuild the index from the base table using the specified preferences. Since modifications made using the UPDATE_SDATA API are not present in the base table, the export/import operation does not preserve these changes.

UPDATE_SDATA modifies temporary metadata it adds in the index table, not the base table. It cannot be used to directly add metadata. For export/import of metadata that is persistent, create a base table column that contains the metadata values. You can then update the metadata through the column in the base table.

UPDATE_SDATA truncates data which is larger than 249 bytes.

Syntax

CTX_DDL.UPDATE_SDATA(
         idx_name     IN VARCHAR2 DEFAULT NULL,
         section_name IN VARCHAR2 DEFAULT NULL,
         sdata_value  IN sys.anydata,
         sdata_rowid  IN rowid,
         part_name    IN VARCHAR2 DEFAULT NULL);

idx_name

Specify the name of the index.

section_name

Specify the name of the SDATA section.

sdata_value

Specify the new SDATA value.

sdata_rowid

Specify the rowid for which the SDATA value needs to be updated.

part_name

Specify the name of the locally partitioned index, if applicable. Specify NULL for the global index.

“SDATA”

“ADD_SDATA_COLUMN”

“ADD_SDATA_SECTION”

See Also: Chapter 8, “Searching Document Sections in Oracle Text” in Oracle Text Application Developer’s Guide