I have varchar2 output parameter in the stored procedure. In the sproc it's changed many times by concatenating new string values. The string became longer than 4000 characters that results in the error. I replaced varchar2 declaration with CLOB. Looks like it works fine without any changes in the code required.
I am wondering if any potential problems can be created by doing this? Is it a good idea to replace varchar2 with CLOB without any code modifications?