ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW

[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

[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.

[chulett]

What version of Oracle? Are you using CAST() at the moment?

[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

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

[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)

[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?