Three Ways to Update a LOB or Entire LOB Data

Figure 9-41 Use Case Diagram: Three Ways to Update a LOB or Entire LOB Data

See: "Use Case Model: Internal Persistent LOBs Basic Operations", for all basic operations of Internal Persistent LOBs.

1. UPDATE a LOB with EMPTY_CLOB() or EMPTY_BLOB()

2. UPDATE a Row by Selecting a LOB From Another Table

3. UPDATE by Initializing a LOB Locator Bind Variable

For Binds of More Than 4,000 Bytes

For information on how to UPDATE a LOB when binds of more than 4,000 bytes are involved, see the following sections in Chapter 7, "Modeling and Design":

• Binds Greater than 4,000 Bytes are Now Allowed For LOB INSERTs and UPDATEs

• Binds of More Than 4,000 Bytes ... No HEX to RAW or RAW to HEX Conversion

• Example: PL/SQL - Using Binds of More Than 4,000 Bytes in INSERT and UPDATE

• Example: PL/SQL - Binds of More Than 4,000 Bytes -- Inserts Not Supported Because Hex to Raw/Raw to Hex Conversion is Not Supported

• Example: PL/SQL - 4,000 Byte Result Limit in Binds of More than 4,000 Bytes When Data Includes SQL Operator