ORA-19011: Character string buffer too small

I got ” ORA-19011: Character string buffer too small ”  error in Oracle database.

ORA-19011: Character string buffer too small

Details of error are as follows.

ORA-19011: "Character string buffer too small"

Cause: The string result asked for is too big to return back

Action: Get the result as a lob instead

Character string buffer too small

This ORA-19011 error is related with the string result asked for is too big to return back.

You should Get the result as a lob instead.

getCLOBVal()

You can use getClobVal() instead of DBMS_LOB.INSTR, getCLOBVal() will solve this error.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )