Using pipelined functions

Hi,

I have a function with the following signature :

FUNCTION FP_NEWFORMAT(searchKey VARCHAR2, QTY NUMBER) RETURN AVA_COLLECTION PIPELINED; basically the number of lines in the function has now exceeded 200 lines which means it is unreadable (almost). What i need to do is refactorise this function, effectively splitting it up into sub functions called from this main application.

How would i go about doing this.

I'm contemplating creating sub functions that are also pipelined and using the OPEN ... FOR to loop through the returned result set.

Is this possible, or do you guys have further suggestions? Thanks in advance Received on Wed Jan 05 2005 - 02:47:55 CST