How to limit the size of returned value from a stored function?

From: Vahid Tadjkarimi <vahidt_at_vitek.com>
Date: 1997/10/08
Message-ID: <343C2516.3B48@vitek.com>#1/1

I've written few stored functions and I want to join some tables and use these functions to build a view. However, when the number of included functions get more than two it fails to create the view and gives a message saying increase your MAXDATA. Where my MAXDATA is already maxed out to 60000.

I noticed when I describe a view built on a function, the size of the retruned value is unblieveably large, something like VARCHAR2(1989)!!! At the function level I've taken necssary measures and made sure that the returned value is not just plain VARCHAR2 as:

FUNCTION a_func (a_var IN a_tab.a1%TYPE,....) RETRUN x_tab.a_varchar2_size_two%TYPE IS BEGIN
...
END; but, still problem presists.

Any ideas to remedy this. Your prompt response will be of great help! Received on Wed Oct 08 1997 - 00:00:00 CDT