OraFAQ Forum: SQL & PL/SQL » ORA-22835 Buffer too small for CLOB to CHAR or BLOB to RAW conversion (

SCOTT@orcl_11g> CREATE TABLE ProjectDetails_tab (pm_comments CLOB) 2 / Table created. SCOTT@orcl_11g> INSERT INTO ProjectDetails_tab SELECT RPAD ('*', 4000, '*') FROM DUAL 2 / 1 row created. SCOTT@orcl_11g> UPDATE ProjectDetails_tab ...

www.orafaq.com