Migrating From Other Database Systems

Is Implicit LOB Conversion Between Different LOB Types Allowed in Oracle8i?

Question

There are no implicit LOB conversions between different LOB types? For example, in PL/SQL, I cannot use:

             INSERT INTO t VALUES ('abc');
                 WHERE t CONTAINS a CLOB column.....

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.

Answer

The PL/SQL restriction has been removed in Oracle8i and you can now insert more than 4K worth of data.