Removed Restrictions

The following restriction has been removed.

Binding More Than 4,000 Bytes of Data

Oracle8i now supports binding more than 4,000 bytes of data to internal LOB columns in INSERT and UPDATE statements.

• If a table has LONG and LOB columns, you can bind more than 4,000 bytes of data for either the LONG column or the LOB columns, but not both in the same statement.

• You cannot bind data of any size to LOB attributes in ADTs. This restriction from prior releases still exists. For LOB attributes, first insert an empty LOB locator and then modify the contents of the LOB using one of the programmatic environment interfaces.

• In an INSERT AS SELECT operation, binding of any length data to LOB columns is not allowed. This restriction from prior releases still exists.