Using pipelined functions

Giganews Newsgroups
Subject: Using pipelined functions
Posted by:  Carlos Correia (cepcorre…@hotmail.com)
Date: 5 Jan 2005

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

Replies