Inserting CLOB into LONG column

From: jimmy.brock <jimmybrock_at_gmail.com>
Date: Wed, 24 Oct 2007 17:47:15 -0000
Message-ID: <1193248035.737473.38470@e34g2000pro.googlegroups.com>

Using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit

We must use the LONG database because of an issue with the reporting tool we are using.

jimmyb> desc p_email_corr
Name Type Nullable Default Comments ------------- ------ -------- ------- -------- EMAIL_CORR_ID NUMBER Y
BODY LONG Y jimmyb> desc email_corr
Name Type Nullable Default Comments

----------------- ------------------ -------- ------- --------

EMAIL_CORR_ID
NUMBER
BODY CLOB Y jimmyb> insert into p_email_corr

  2 select email_corr_id, body

  3 from email_corr

  4 where email_corr_id = 1671568;

select email_corr_id, body

                      *

ERROR at line 2:

ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4214, maximum: 4000)

Isn't the maximum size for LONG 2GB ?
Does anyone know of a work around? Received on Wed Oct 24 2007 - 12:47:15 CDT