when a LONG RAW (MAX 2GB bytes) is read into a RAW PL/SQL variable (MAX 32767 bytes).
clob类型做为变量最大只能32K,但做为字段可以到2G。
LONG is a variable length PL/SQL datatype and database column type that is used to store character data. In PL/SQL the LONG is like a VARCHAR2 datatype except that is can store 32780 bytes (VARCHAR2 is limited to 2000 bytes). The LONG database column has a width of 2GB. 32767 bytes for PL/SQL variables 2GB bytes for database columns Sample Declarations A PL/SQL declaration - maximum width DECLARE book_paragraph LONG; -- up to 32767 bytes BEGIN ...A table declaration with a LONG column that stores 2GB CREATE TABLE ... (book LONG, ...
32767 bytes for PL/SQL variables
2GB bytes for database columns
Sample Declarations
A PL/SQL declaration - maximum width
DECLARE
book_paragraph LONG; -- up to 32767 bytes
BEGIN
...A table declaration with a LONG column that stores 2GB
CREATE TABLE ...
(book LONG,
...