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
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Re: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to
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
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
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:
I will add one more thing, which was implicit in my first post:
Code: Select all
dbms_lob.substr(YourBLOBColumnName,1,4000)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>