In Oracle 10G, when we return from a java stored a response which size can be greater than 32767 (PLSQL limit for a varchar2) then we get “ORA-24345: A TRUNCATION OR NULL FETCH ERROR ” error.
To avoid getting this error is to return a Clob instead of Varchar2.
Steps to be followed

Create a [...]

Continue reading about Good to use CLOB instead of VARCHAR2 in Java Stored Procedure