Three Ways Of Inserting One or More LOB Values into a Row

Figure 9-11 Three Ways of Inserting LOB Values into a Row

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

There are three different ways of inserting LOB values into a row:

1. LOBs may be inserted into a row by first initializing a locator -- see INSERT a LOB Value using EMPTY_CLOB() or EMPTY_BLOB()

2. LOBs may be inserted by selecting a row from another table-- see INSERT a Row by Selecting a LOB From Another Table.

3. LOBs may be inserted by first initializing a LOB locator bind variable -- see INSERT Row by Initializing a LOB Locator Bind Variable.

Usage Notes

For Binds of More Than 4,000 Bytes

For guidelines on how to INSERT into 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