SQL & PL/SQL

Hi,

I want to know if there is a way to write a select query on a function call which returns a varchar of more than 4000 characters.

CREATE OR REPLACE FUNCTION FUNC1

RETURN VARCHAR2

IS

str VARCHAR2(32767);

BEGIN

     str := <some string greater than 4000 char>;

      RETURN str;

END;

/

SELECT FUNC1 from dual; ---- This gives an PL/SQL numeric or value error. Character string buffer too small.

Is there any way to resolve this?

Thanks