problem of inserting a long string of characters :ORA-22835: Taille de tampon insuffisante pour la c [message #670207] |
Mon, 18 June 2018 08:22 |
|
achraf87
Messages: 6 Registered: May 2012 Location: France
|
Junior Member |
|
|
Hello Team ,
I'm trying to insert into a table " TEST COM " the result of selecting rows of another table.
I used the wm_concat function .
/**********/
insert into COMMENTAIRE_TEST (SELECT wm_concat((DBMS_LOB.SUBSTR(COM_TEXTE,4000,1))) as test
FROM commentaire
--where COM_NUMREF=1416
GROUP BY COM_NUMREF)
/************/
when I execute the query, I have the following error
/*****************************************************************************
Rapport d'erreur -
Erreur SQL : ORA-22835: Taille de tampon insuffisante pour la conversion de CLOB en CHAR ou de BLOB en RAW (réelle : 46972, maximum : 4000)
22835. 00000 - "Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: %s, maximum: %s)"
*Cause: An attempt was made to convert CLOB to CHAR or BLOB to RAW, where
the LOB size was bigger than the buffer limit for CHAR and RAW
types.
Note that widths are reported in characters if character length
semantics are in effect for the column, otherwise widths are
reported in bytes.
*Action: Do one of the following
1. Make the LOB smaller before performing the conversion,
for example, by using SUBSTR on CLOB
2. Use DBMS_LOB.SUBSTR to convert CLOB to CHAR or BLOB to RAW.
/*********************************************************************************
I need your help please
thank you in advance
|
|
|
|
|