Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using pipelined functions

Using pipelined functions

From: Carlos Correia <cepcorreia_at_hotmail.com>
Date: 5 Jan 2005 00:47:55 -0800
Message-ID: <1104914875.400350.251270@c13g2000cwb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US