PL/SQL: character string buffer too small

I have a PL/SQL function that returns VARCHAR2. When the size of the return string is greater than about 2000 characters I get an ORA-06502: PL/SQL: numeric or value error: character string buffer too small during the return statement.

So how should one return varchar2 strings up to 32000 bytes when this error occurs all the time ?

Andreas Received on Tue May 23 2000 - 04:19:29 CDT