|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Frequently Asked Questions about LOBs, 2 of 12
Can I insert or update any length of data for a LOB column? Am I still restricted to 4K. How about LOB attributes
When inserting or updating a LOB column you are now not restricted to 4K.
For LOB attributes, you must use the following two steps:
Example: Copy Long to LOB Using SQL :
Does this work if the data in LONG or LONGRAW is > 64K?
Yes. All data in the LONG is copied to the LOB regardless of size.