Page 1 of 1
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW
Posted: Wed Oct 28, 2009 3:29 am
by DWH-M
HI
I am trying to implement the data stage server job, one of the column i am trying to convert the CLOB data type to char or varchar,
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4450, maximum: 4000)
could any one suggest me how to proceed the above issue.
Immediate solution, Highly appreciated.
thanx
Kumar
Posted: Wed Oct 28, 2009 4:00 am
by ArndW
This is an Oracle VarChar() and VarChar2() limitation and as the error is an Oracle one you cannot get rid of it. One option is to split the LOB object into chunks of 4000 that will fit into a buffer.
Posted: Wed Oct 28, 2009 7:32 am
by chulett
What version of Oracle? Are you using CAST() at the moment?
Re: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to
Posted: Thu Oct 29, 2009 2:53 am
by DWH-M
I am using oracle 10g, i tried with many ways but its not allowing to continue, its giving same as below error, it needs to be closed,
please help needed on urgent issue close. thanx in advance
Regards
Kumar
DWH-M wrote:HI
I am trying to implement the data stage server job, one of the column i am trying to convert the CLOB data type to char or varchar,
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4450, maximum: 4000)
could any one suggest me how to proceed the above issue.
Immediate solution, Highly appreciated.
thanx
Kumar
Posted: Thu Oct 29, 2009 3:52 am
by ArndW
You really should know better by now than to try to exhort people on DSXChange to work harder for you by stating that the problem is
urgent. In addition, you didn't respond to Craig's question nor did you add what you tried and what the error(s) were.
I will add one more thing, which was implicit in my first post:
Code: Select all
dbms_lob.substr(YourBLOBColumnName,1,4000)
Posted: Thu Oct 29, 2009 7:42 am
by chulett
Which was why I asked for the Oracle version, to see if that package was available.
Is this is an
urgent issue, have you involved your official support provider?