|Subject:||Using pipelined functions|
|Posted by:||Carlos Correia (cepcorre…@hotmail.com)|
|Date:||5 Jan 2005|
I have a function with the following signature :
FUNCTION FP_NEWFORMAT(searchKey VARCHAR2, QTY NUMBER) RETURN
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