DBMS_LOB.SUBSTR failed to retrieve 4000 characters
Date: Thu, 13 Nov 2008 11:32:45 -0800 (PST)
Oracle throws the error when trying to retrieve first 4000 characters from a CLOB column
SELECT DBMS_LOB.SUBSTR(clob_column,4000, 1) FROM tbl
ORA-06502: PL/SQL: numeric or value error: character string buffer too
ORA-06512: at line 1
Depends on the row it works fine only when I reduce the chunk size
from 4000 to 3550 or even less.
I run it on Oracle 11G
Please advice what is a problem.
Yuri Received on Thu Nov 13 2008 - 13:32:45 CST