错误-ORA-22835:缓冲区太小，无法将CLOB转换为CHAR或将BLOB转换为RAW [英] Error- ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion

问题描述

我试图读取blob消息并将其显示为我的程序之一中的变量，但出现以下错误:

I am attempting to read a blob message and display it as a variable in one of my procedures, but am getting the error below:

错误-ORA-22835:缓冲区太小，无法将CLOB转换为CHAR或将BLOB转换为RAW 转化(实际:9923，最大:2000)

Error - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9923, maximum: 2000)

我已经在Google上进行了搜索，并找到了如下建议来修剪Blob消息的建议，但宁愿将完整的Blob消息显示为字符串.

I have googled and found a suggestion to trim the blob message as below, but would rather display the complete blob message as a string.

UTL_RAW.CAST_TO_VARCHAR2(dbms_lob.substr(variable_name,2000,1)) 

如何显示完整的消息?我可以在数据库或过程级别上进行设置吗?

How can I display the complete message? Is there a setting on either the database or procedure level that I can change?

推荐答案

我通过使用

http://www.dba-oracle.com/t_convert_blob_varchar_datatype.htm

这篇关于错误-ORA-22835:缓冲区太小，无法将CLOB转换为CHAR或将BLOB转换为RAW的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！