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:
Error - ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 9923, maximum: 2000)
I have googled and found a suggestion to trim the BLOB
message as below, but I 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?
I got this working by using the option described here: