|Oracle9i Application Developer's Guide - Large Objects (LOBs)
Release 1 (9.0.1)
Part Number A88879-01
Frequently Asked Questions about LOBs, 10 of 12
There are no implicit LOB conversions between different LOB types? For example, in PL/SQL, I cannot use:
Do you know if this restriction still exists in Oracle8i? I know that this restriction existed in PL/SQL for Oracle8 but users could issue the INSERT statement in SQL as long as data to insert was <4K. My understanding is that this <4K restriction has now been removed in SQL.
The PL/SQL restriction has been removed in Oracle8i and you can now insert more than 4K worth of data.