|Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)
Part Number A89852-02
DBMS_WM , 8 of 52
This procedure allows LOB columns (BLOB, CLOB, or NCLOB) in version-enabled tables to be modified. Use this procedure only if a version-enabled table has any LOB columns.
Name of the table containing one or more LOB columns. The name is not case sensitive.
This procedure is intended for use only with version-enabled tables containing one or more LOB columns. The CopyForUpdate must be used because updates performed using the DBMS_LOB package do not fire
INSTEAD OF triggers on the versioning views. Workspace Manager creates
INSTEAD OF triggers on the versioning views to implement the copy-on-write semantics. (For non-LOB columns, you can directly perform the update operation, and the triggers work.)
See the following example.
The following example updates the
SOURCE_CLOB column of
TABLE1 for the document with
DOC_ID = 1.
Declare clob_var Begin /* This procedure copies the lob columns if necessary, i.e., if the row with doc_id = 1 has not been versioned in the current version */ vm.copyForUpdate('table1', 'doc_id = 1'); select source_clob into clob_var from table1 where doc_id = 1 for update; dbms_lob.write(clob_var,<amount>, <offset>, buff); End;