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:
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.
The PL/SQL restriction has been removed in Oracle8i and you can now insert more than 4K worth of data.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|