<div>
What size are you passing to DBMS_LOB.SUBSTR? Try something really small to verify.<br />

</div>


What size are you passing to DBMS_LOB.SUBSTR? Try something really small to verify.


<div>
I just double checked...<br />
This issue is fixed in 10.2.0.3 (Server Patch Set) and <br />
11.1.0.6 (Base Release) <br />
&nbsp; <br />

</div>


I just double checked...
This issue is fixed in 10.2.0.3 (Server Patch Set) and
11.1.0.6 (Base Release)
 


<div>
<div class="content wysiwyg-content">
I am querying a view in Oracle 10g and received this error below:<br />
ora-22835 buffer too small for clob to char or blob to raw conversion<br />
<br />
The problematic field datatype is blob and I need to convert it to text to UNION several tables. I tried using DBMS_LOB.SUBSTR but still getting the same error. Any idea?
</div>
</div>


I am querying a view in Oracle 10g and received this error below:
ora-22835 buffer too small for clob to char or blob to raw conversion

The problematic field datatype is blob and I need to convert it to text to UNION several tables. I tried using DBMS_LOB.SUBSTR but still getting the same error. Any idea?

ora-22835 buffer too small for clob to char or blob to raw conversion

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.