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